Formula Needed

carla7216

New Member
Joined
Aug 13, 2009
Messages
23
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....

Please help! I'd greatly appreciate it so much.... :)
 

Some videos you may like

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
Joined
Feb 16, 2002
Messages
8,458
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....

Please help! I'd greatly appreciate it so much.... :)

Try using

COUNTIF for the first question

SUMIF for the other two questions
 

carla7216

New Member
Joined
Aug 13, 2009
Messages
23
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
Joined
Feb 16, 2002
Messages
8,458
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
Joined
Aug 13, 2009
Messages
23
IT WORKS! :rolleyes:
THANK YOU SO MUCH. I REALLY APPRECIATE YOUR HELP!
GOD BLESS YOU!!!!
 

Watch MrExcel Video

Forum statistics

Threads
1,109,029
Messages
5,526,340
Members
409,697
Latest member
christopherlewis1620

This Week's Hot Topics

Top