I think I opened a can of worms here. I'm new at excel and I'm trying to put
together a "Pass"/"Fail" table within five groups which has about four
different sub group.

Now, with the forumal that you wrote, Which I have no idea how to read it,
how do I make the formula check specific cells and count only "P" for pass
along the range c4:v4? For example I only want to chec cell (c4,g4,k4,o4,s4)??

Thanks a bunch,
JS


"Teethless mama" wrote:

You don't really need IF function

=SUMPRODUCT(--(MOD(COLUMN(A1:F1),2)=1),--(A1:F1="P"))

just enter


"Toppers" wrote:

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,