# Formula Needed

#### carla7216

##### New Member
Hello everyone, I need your help with a formula. I have a spreadsheet that consist of multiple telephone numbers, minutes/seconds used and charge.

I need a formula that will calculate the following:

How many times the number was called...
The total minutes was used for that number....
The total amount that was charged for that number....

### Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

#### Brian from Maui

##### MrExcel MVP
Hello everyone, I need your help with a formula. I have a spreadsheet that consist of multiple telephone numbers, minutes/seconds used and charge.

I need a formula that will calculate the following:

How many times the number was called...
The total minutes was used for that number....
The total amount that was charged for that number....

Try using

COUNTIF for the first question

SUMIF for the other two questions

#### carla7216

##### New Member
Hi Brian,
Thanks so much for replying. I greatly appreciate it.
I knew it was the COUNTIF and SUMIF, but where I get stuck is knowing how to use the other symbols like: *(),:, etc. I don't know when and where to place them.

#### Brian from Maui

##### MrExcel MVP
Hi Brian,
Thanks so much for replying. I greatly appreciate it.
I knew it was the COUNTIF and SUMIF, but where I get stuck is knowing how to use the other symbols like: *(),:, etc. I don't know when and where to place them.

The syntax for COUNTIF

=COUNTIF(Range,Criteria) or =COUNTIF(A1:A100,"808-555-5555")

Where A1:A100 house telephone numbers and 808 is the phone number

For SUMIF

=SUMIF(Range,Criteria,RangeToSum)

=SUMIF(A1:A100,"808-555-5555",B1:B100)

Where A1:A100 houses telephone numbers, 808-555-5555 is the criteria and B1:B100 range to sum

#### carla7216

##### New Member
Ok, I'll give that a try and let you know if it worked.

Thanks again!

#### carla7216

##### New Member
IT WORKS!
THANK YOU SO MUCH. I REALLY APPRECIATE YOUR HELP!
GOD BLESS YOU!!!!

Replies
3
Views
43
Replies
1
Views
70
Replies
13
Views
154
Replies
4
Views
37
Replies
23
Views
650