You're welcome
Sorry about the typo..
Cimjet
"Amy-Marie" wrote in message
...
On Jan 30, 8:21 pm, "Cimjet" wrote:
Hi again
If your trying to count the (1's) matching the letter P on the same row then
maybe this is what you want.
=SUMPRODUCT(('Employee Details'!V4:V93="P",)*('Employee Details'!Y4:Y93=1))
Cimjet"Amy-Marie" wrote in message

...







Can anyone see what is wrong with this function? =IF('Employee
Details'!V4:V93="P",COUNTIF('Employee Details'!Y4:Y93,1),0) - There
are loads of "P"'s in that range but it is still showing 0 as if it is
false. How this makes sense. Its driving me mad!!!

Yay it worked, thank you very much!!! :-)