Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summation Formula Needed
I have a spreadsheet with several rows of data. Each row's data corresponds to a code that appears in the 1st field of the row. Example: Codes:..............Revenue:......Responses: AAAAAAA1..........$1,000.........500 BBBBBBBB3.........$2,000.........200 CCCCCCC1.........$3,000.........300 DDDDDDD2.........$4,000.........9000 What formula would enable me to sum up the revenue & responses on rows that only correspond to codes that end in '1'? Addie -- addie ------------------------------------------------------------------------ addie's Profile: http://www.excelforum.com/member.php...o&userid=25526 View this thread: http://www.excelforum.com/showthread...hreadid=513868 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
continuous sum formula needed | Excel Discussion (Misc queries) | |||
Formula Help Needed | Excel Discussion (Misc queries) | |||
More Help Needed with Count formula | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Help! Formula needed. | Excel Discussion (Misc queries) |