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,

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,

If you want every other cell:

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

In article ,
Juan S. <Juan 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,

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,

Thanks!

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

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,

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

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



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,

--

Dave Peterson

Try this:

=SUMPRODUCT(--(MOD(COLUMN(C4:S4)+1,4)=0),--(C4:S4="P"))

Biff

"Juan S." wrote in message
...
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,