HOW DO I CALCULATE THE NUMBER OF RESULTS FROM AN ENTIRE ROW

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sashasaurav - 01 Feb 2008 02:40 GMT

IF SUPPOSE THESE ARE MY VALUES IN A SINGLE ROW.
P N/A P \ P B D \ \ P

NOW I WANT TO CALCULATE ALL THE
NUMBER OF P'S
NUMBER OF B'S ETC

HOW DO I CALCULATE THIS ?

PLEASE HELP ME WITH THIS

Reply to this Message

Dave Peterson - 01 Feb 2008 02:43 GMT

=countif(1:1,"P")
will count the number of P's in row 1

> IF SUPPOSE THESE ARE MY VALUES IN A SINGLE ROW.
> P N/A P \ P B D \ \ P
[quoted text clipped - 6 lines]
>
> PLEASE HELP ME WITH THIS

Signature

Dave Peterson

Reply to this Message

sashasaurav - 01 Feb 2008 03:08 GMT

HI Dave
I Need to count the number of p's and put in the result in one cell
So if i have an row like the following one

P n/a P B P F \
P B F

i have 4 P's here .

so i need a formula for this one because i cannot count as i have 1000
values in each row and have 57 rows of this kind .

So is there any formula which gives me all the number of P's in the
whole row

> =countif(1:1,"P")
> will count the number of P's in row 1
[quoted text clipped - 13 lines]
>
> Dave Peterson

Reply to this Message

Dave Peterson - 01 Feb 2008 03:20 GMT

=countif(1:1,"P")
will count the number of P's in row 1

=countif(a1:x1,"p")
will count then number of p's in A1:X1

I don't understand your followup question, though.

> HI Dave
> I Need to count the number of p's and put in the result in one cell
[quoted text clipped - 28 lines]
> >
> > Dave Peterson

Signature

Dave Peterson

Reply to this Message

Max - 01 Feb 2008 07:39 GMT

> P n/a P B P F \
> P B F

If you meant that the data you posted is all in a single cell, say in A1,
you could try this in B1:
=LEN(A1)-LEN(SUBSTITUTE(A1,"P",""))
to get the count of the "P" in A1

Copy B1 down as required

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Reply to this Message

Shane Devenshire - 03 Feb 2008 06:11 GMT

Hi,

You can combine the two answers you already have to check multiple how many
times the letter P appears in a set of cells, such as 3 times in A1, 4 times
in B1 and so on with the following formula:

=SUMPRODUCT((LEN(1:1)-LEN(SUBSTITUTE(1:1,"p",""))))

Cheers,
Shane Devenshire

> IF SUPPOSE THESE ARE MY VALUES IN A SINGLE ROW.
> P N/A P \ P B D \ \ P
[quoted text clipped - 6 lines]
>
> PLEASE HELP ME WITH THIS

Reply to this Message