Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Another SUMIF question
My book is telling me that I can't use multiple conditions with a SUMIF
statement but other sources are telling me I can. Either way, it's not working! My situation: Look at data in $V$2:$V$144 (range = "group"). If cells in "group" = "Broth" then look at $Y$2:$Y$144 (range = "bldg"). If "bldg" = "1" then sum corresponding cells in $R$2:$R$144 (range = "fcst"). This is one of my attempts - feeble... =SUM(IF(group="Broths",IF(bldg="1",fcst,0))) Help, please! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumif of Sumif perhaps? | Excel Discussion (Misc queries) | |||
SUMIF Question Criteria | Excel Worksheet Functions | |||
SUMIF, multiple criteria | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
sumif Question | Excel Discussion (Misc queries) |