Help :O(

J

Juan S.

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,
 
T

Toppers

Try:

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

entered with Ctrl+shift+enter
 
J

JE McGimpsey

If you want every other cell:

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

Teethless mama

You don't really need IF function

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

just enter
 
J

Juan S.

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
 
D

Dave Peterson

If it's only a few cells, I'd use something like:

=(A1="p")+(C1="p")+(E1="p")
 
Top