Help :O(
Try:
=SUMPRODUCT(--(IF(MOD(COLUMN(A1:F1),2)=1,1)),--(A1:F1="P"))
entered with Ctrl+shift+enter
"Juan S." wrote:
If I have for example, A1=P, B1=F, C1=P, D1=P, E1=P and F1=F..... what
formula do I use to just count "P" for ONLY (A1, C1, E1)?
I'm looking for a formula that would only count specific cells.
Thanks,
|