Dear all,

I am using SUMPRODUCT to use 2 criteria, in column A (criteria="M"),
then column B (criteria="R"), to then sum the totals in column N.

=SUMPRODUCT("'Dashboard'!A9:A500,M","'Dashboard'!B 9:B500,R",'Dashboard'!N9:N500)

I keep getting "VALUE!" as an error message.

NB - The data is on one worksheet and the formula on another, however
I've even tried testing the formula on the same worksheet, but to no
avail. Please help, I'm at a loss as to what I'm doing wrong...

Alternatively - any suggestions on how I can acheieve what I want using
something else (without creating extra working sheets or columns, as
it's not my spreadsheet to redesign - sigh) would be MUCH appreciated!

Thanks,
Cath


--
CathB
------------------------------------------------------------------------
CathB's Profile: http://www.excelforum.com/member.php...o&userid=34291
View this thread: http://www.excelforum.com/showthread...hreadid=540573