You could try

=SUMPRODUCT(--(Sheet1!A1:A1000Sheet2!B11),Sheet1!B1:B1000+Sheet1 !C1:C1000+Sh
eet1!D1:D1000+Sheet1!E1:E1000+Sheet1!F1:F1000)

but it doesn't look that much simpler to me.

--
HTH

Bob Phillips

"mminsf" wrote in
message ...

I'm trying to figure out a cleaner/easier way to do this:


=SUMIF(Sheet1!A:A,Sheet2!B11,Sheet1!C:C)+SUMIF(She et1!A:A,Sheet2!B11,Sheet1!
D:D)+SUMIF(Sheet1!A:A,Sheet2!B11,Sheet1!E:E)+SUMIF (Sheet1!A:A,Sheet2!B11,She
et1!F:F)

Any ideas?


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