Hi,

I am using the below sum product formula:

=SUMPRODUCT(('19 June'!$C$2:$C$984=$C2)*('19 June'!$D$2:$D$984=$D2)*('19 June'!$F$2:$F$984=I$1)*('19 June'!$B$2:$B$984=$B2)*('19 June'!$A$2:$A$984=$A2))

What i trying to do now is:

'19 June'!$F$2:$F$984=I$1 - this part of the forumla means if in column 'F' = the title in column 'I' ----- this counts the amount of times the title appears.

what i need to do is use sumproduct formula, but say if it equals column A1, b1, c1, d1....then not to count them but only count anything else is not = to A1, B1, C1, D1,...etc.

I hope its clear what im asking for above.

Thanks in advance