That may very well work, but it is an array formula so needs to be entered by
using ctrl-shift-enter (not just enter). Also you state Broth in the
description and Broths in the formula, perhaps just a typo? You may also
want to check out Bob Phillip's white paper which explains how to use
sumproduct. It made a believer out of me.
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
--
Kevin Vaughn
"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!