| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum Value of rows based on two common fields
Hi,
Trust I explain this easily and someone can help. My spreadsheet has three columns; date, unique venue ID number and a value - eg Date Venue Number Score Overall Score 1/1/09 1234 10 ?? 1/1/09 1234 8 ?? 1/1/09 6789 9 ?? 4/2/09 1234 6 ?? I need a forth column to calculate the sum value for each venue based on the same date as venues can have multiple rows with different scores for the same date. I don't mind if each row has the sum value figure for the same venue on the same date as I can de-dupe based on date/venue number. Any assistance greatly appreciated. -- JDG |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combining two ranges based on common a common value | Excel Discussion (Misc queries) | |||
| Combining spread sheets with common fields | Excel Discussion (Misc queries) | |||
| Add data based on a common field | Excel Worksheet Functions | |||
| how can I convert data with fields in rows to fields as columns | Excel Discussion (Misc queries) | |||
| filtering common fields | Excel Discussion (Misc queries) | |||
Threaded Mode
