Hello, Excel experts,
I'm trying to minimize my Verizon cell phone bill by determining which numbers I should put on the "Friends & Family" list.
I can specify 10 phone numbers, and any calls to/from those numbers are free.
So, I've downloaded the data, and sorted it all by the Phone number.
It tells me the phone number and the minutes used on each phone call,
but I want to Create this "Total" column...
by adding up the "minutes" used for each phone number. Using Excel 2007.
Number Minutes Total
203-555-1234 1
203-555-1234 6
203-555-1234 12
203-555-1234 3 22
562-555-7777 9
562-555-7777 14
562-555-7777 8
562-555-7777 7 38
714-555-2222 3
714-555-2222 1
714-555-2222 15 19
949-555-1111 9
949-555-1111 3
949-555-1111 1
949-555-1111 2
949-555-1111 5
949-555-1111 7 27
So, for example, I'd put 562-555-7777 on the Friends & Family list.
Would be nice if the "Total" column is populated ONLY for the Last phone number.
How can this be done?
Thanks in advance.
Mark53
Bookmarks