| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SumIF for more than one condition
Hi,
I am wanting to sum up data in a column only when it corresponds to data in 2 other columns, i.e. Stage Person Cost Stage A Person 1 £5 Stage A Person 2 £2 Stage A Person 4 £8 Stage A Person 1 £7 Stage A Person 1 £10 Stage B Person 4 £12 Stage B Person 4 £1 Stage C Person 5 £3 What is the easiest way of calculating how much it costs for Person 1 in Stage A? (actual spreadsheet contains hundreds of rows) cheers, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumif banding on a condition | Excel Worksheet Functions | |||
| Sumif, having two condition | Excel Worksheet Functions | |||
| sumif with or< condition | Excel Discussion (Misc queries) | |||
| sumif with or< condition | Excel Worksheet Functions | |||
| sumif on more than one condition | Links and Linking in Excel | |||
Threaded Mode
