=SUMPRODUCT(($V$2:$V$144="Broths")*($Y$2:$Y$144=1) ,$R$2:$R$144)

This is what finally worked. Turned out that I needed to take off the ""
around "1" since it was a numeric, not text value.

Thanks to all of you, especially for that SUMPRODUCT info page.




"tawtrey(remove this " wrote:

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!