Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nested IF / SUMIF statements
I'm trying to determine a sum via a number of SUMIF's, and am failing badly !
To explain, I have 4 columns with data in - Names, Town, Month, Sales. I need to show the total Sales number where the Names and Town and Month are the same. eg =sumif(a:a="Smith",sumif(b:b="London",sumif(c:c="J an",(d:d)))) -- Many thanks Ian |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nested if statements | Excel Worksheet Functions | |||
nested if statements | Excel Worksheet Functions | |||
nested if statements | Excel Worksheet Functions | |||
nested if statements | Excel Worksheet Functions | |||
Nested IF statements | Excel Discussion (Misc queries) |