Thanks for your help guys, unfortunately I am now getting a result of
"0"; i.e. none of the rows fit appear to fit the criteria, though I
know they do.

I've used the same data set and critera columns in other formula on my
spreadsheet - even using the SUMPRODUCT function - and those other
formula yielf correct results, so I know the data is clean and not
causing my problem.

Currently, I am able use the SUMPRODUCT function to *count* the number
of rows, within the multiple criteria set in column A and B, but I
simply can't get the function to *sum* the figures in column N, given
criteria set in columns A and B.

Does anyone have any further thoughts? (Thank you!!!)
Cath


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