Formula Needed

[carla7216]

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....

 

[Brian from Maui]

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]

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]

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]

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

Thanks again!

 

[carla7216]

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