hi arthurbr,

I've just tried using that but found one small problem... the formula you used is for a set range of cells, but I need it for the entire column... I changed it from:
=SUMPRODUCT(($B$3:$B$10=B3)*($D$3:$D$10="fail"))
to:
=SUMPRODUCT(($B:$B=B3)*($D$3:$D$10="fail"))
but now the cell text says #NUM!
I tried changing it instead to:
=SUMPRODUCT(($B$3:$B$99=B4)*($D$3:$D$10="fail"))
and now get #N/A! as the cell text
I presume this is because those cells are empty... is there anyway around this?