IF THERE ARE 9 P AND 5 A IN A ROW THEN HOW TO CALCULATE
 

I WANT TO CALCULATE NUMBER OF "P" AND NUMBER OF "A" IN A ROW SO WHAT SHOULD
BE THE FORMULA FOR THE SAME?

IF THERE ARE 9 P AND 5 A IN A ROW THEN HOW TO CALCULATE
 

=SUM(COUNTIF(A2:H2,{"P";"A"}))


please refrain from using all caps, it is considered rude

--


Regards,


Peo Sjoblom


"SRINIVAS" wrote in message
...
I WANT TO CALCULATE NUMBER OF "P" AND NUMBER OF "A" IN A ROW SO WHAT SHOULD
BE THE FORMULA FOR THE SAME?

IF THERE ARE 9 P AND 5 A IN A ROW THEN HOW TO CALCULATE
 

Hi,

You can use COUNTIF function.

=COUNTIF(RANGE,"P")
=COUNTIF(RANGE,"A")

Regards,
Soundar.

"SRINIVAS" wrote:

I WANT TO CALCULATE NUMBER OF "P" AND NUMBER OF "A" IN A ROW SO WHAT SHOULD
BE THE FORMULA FOR THE SAME?

IF THERE ARE 9 P AND 5 A IN A ROW THEN HOW TO CALCULATE
 

For row #13:

=COUNTIF(13:13,"P")+COUNTIF(13:13,"A")
--
Gary''s Student - gsnu200751


"SRINIVAS" wrote:

I WANT TO CALCULATE NUMBER OF "P" AND NUMBER OF "A" IN A ROW SO WHAT SHOULD
BE THE FORMULA FOR THE SAME?

IF THERE ARE 9 P AND 5 A IN A ROW THEN HOW TO CALCULATE
 

You didn't mention if there was *nothing else* in the cells except for the
p's & q's,
or if the p's and q's could occupy the same cell.

This counts *all* the p's and q's in Row1, no matter where they a

=SUMPRODUCT(LEN(1:1)-LEN(SUBSTITUTE(UPPER(1:1),UPPER({"p";"q"}),"")))


--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===



"SRINIVAS" wrote in message
...
I WANT TO CALCULATE NUMBER OF "P" AND NUMBER OF "A" IN A ROW SO WHAT SHOULD
BE THE FORMULA FOR THE SAME?

IF THERE ARE 9 P AND 5 A IN A ROW THEN HOW TO CALCULATE
 

Thanks Soundar

The Function which you mentioned here is worked for me and resolved my
problem.

Thanks once again

Regards

Srinivas

"Soundar" wrote:

Hi,

You can use COUNTIF function.

=COUNTIF(RANGE,"P")
=COUNTIF(RANGE,"A")

Regards,
Soundar.

"SRINIVAS" wrote:

I WANT TO CALCULATE NUMBER OF "P" AND NUMBER OF "A" IN A ROW SO WHAT SHOULD
BE THE FORMULA FOR THE SAME?