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

=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?

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?

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?

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?

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?