Hi all,

I've finally got the formula to work! Hurrah! Thanks Dav.

In case anyone wanted to know the end of the story: it turns out that
my data was clean enough for a SUMPRODUCT = (count of rows that apply),
but not clean enough for a SUMPRODUCT = sum(applicable numbers in column
N).

There were cells in column N with comments such as "n/a". I've since
cleaned those up and the forumla works fine.

It pains me that I will still have to amend the reporting data that
gets to me every month in order to process it, as the formula can't
cope with cells that clearly aren't numbers; but at least my
spreadsheet works! Joy! Thank you very much all!

Cath


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