mminsf Wrote:
thanks so much for your quick reply! I gave it a try, but I'm getting a
#value! error. any thoughts on how I might fix that?

Aladin has just pointed out that that happens because you have values
like "" in the ranges to sum (his post to follow -- thanks Aladin, I
hadn't thought about that :)). Acordingly, try the following
formula...

=SUM(IF(Sheet1!A1:A100=Sheet2!B11,IF(Sheet1!C1:F10 0<"",Sheet1!C1:F100)))

...confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

Hope this helps!


--
Domenic
------------------------------------------------------------------------
Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785
View this thread: http://www.excelforum.com/showthread...hreadid=383325