It's not accepting my formula with the ";" before fcst.


"Ardus Petus" wrote:

=SUMPRODUCT((group="Broth")*(bldg="1");fcst)

HTH
--
AP

"tawtrey(remove this "
osoft.com a écrit dans le
message de news: ...
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!