Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HOW DO I CALCULATE THE NUMBER OF RESULTS FROM AN ENTIRE ROW
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HOW DO I CALCULATE THE NUMBER OF RESULTS FROM AN ENTIRE ROW
=countif(1:1,"P")
will count the number of P's in row 1 sashasaurav wrote: 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 -- Dave Peterson |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HOW DO I CALCULATE THE NUMBER OF RESULTS FROM AN ENTIRE ROW
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 On Jan 31, 8:43*pm, Dave Peterson wrote: =countif(1:1,"P") will count the number of P's in row 1 sashasaurav wrote: 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 -- Dave Peterson |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HOW DO I CALCULATE THE NUMBER OF RESULTS FROM AN ENTIRE ROW
=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. sashasaurav wrote: 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 On Jan 31, 8:43 pm, Dave Peterson wrote: =countif(1:1,"P") will count the number of P's in row 1 sashasaurav wrote: 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 -- Dave Peterson -- Dave Peterson |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HOW DO I CALCULATE THE NUMBER OF RESULTS FROM AN ENTIRE ROW
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 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HOW DO I CALCULATE THE NUMBER OF RESULTS FROM AN ENTIRE ROW
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 "sashasaurav" wrote in message ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto-readjust row height to show entire formula results | Excel Discussion (Misc queries) | |||
Display entire 19 digit number | Excel Discussion (Misc queries) | |||
Copying a region in excel results in the entire worksheet being pa | Excel Worksheet Functions | |||
Formula Help to Calculate Quarterly Results | Excel Discussion (Misc queries) | |||
Use a text box to calculate and show results in a user form | Excel Discussion (Misc queries) |