Domenic Wrote:
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!

you're my new best friend -- thanks so much, it worked perfectly!


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