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'!B9: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