| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple value lookups from a table to select & sum data from colu
I have a task to analyze GPRS usage on a company's monthly cellular bill for
each individual phone. There are many telephones in the fleet and the rawdata bill contains line items for all phones and different call types (GPRS, GPRS Roaming, CSD, etc ). I am trying to extract and summarize total usage of each call type for each individual tel number automatically (the report varies in length each month): My data set is in the following format Tel Nr. Call Type Data (KB) used 012345678 GPRS 98762 033465756 GPRS 78923 012345678 GPRS ROAM 78902 056434231 GPRS ROAM 12323 012345678 GPRS 89564 I would like to be able to create a formula in a cell in my report that allows me to look down the line items, pick out and sum total the data used values that meet the criteria I set for the data in this case Tel Nr= 012345678 and Call type is GPRS giving an answer of 188326 KB GPRS used for 012345678. Thanks in advance! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMPRODUCT: Can you use this and sum the values from multiple colu | Excel Discussion (Misc queries) | |||
| multiple data validation lookups | Excel Discussion (Misc queries) | |||
| How do I randomly select data elements from a table? | Excel Discussion (Misc queries) | |||
| select data from a table | Excel Worksheet Functions | |||
| I can not select Pivot Table on my Data Menu | Excel Discussion (Misc queries) | |||
Threaded Mode
