which formula do i have to use ?

H

Herman Guns

I do have difficulties with the following thing :

I have a row with different cell
in each cell there is a letter, for example "P" or "L" or "S"

At the end of the row I want to totalise how much of each letters there are
in a row
So on the same row there is a cell where I want to see the number of how
much "P" there are in a row - next cell how much "L" - next cell how much
"S".
which formula do i have to use

SCHEME


Tot P
Tot S TotL

P P P S L P L P nP nS
nL


which formula do i have to use so that in cell "nP" is see the number : 5

which formula do i have to use so that in cell "nS" is see the number : 1

which formula do i have to use so that in cell "nL" is see an number : 2


Txs for your help !


Herman
 
B

Bob Phillips

=COUNTIF(A5:AZ5,"p")

etc.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

(Advanced Excel) Figuring out a formula of continuous progressiontrying to create 19 Formulas into O 5
Scrabble Value calculation for Welsh words 0
Copy formula 6
Find largest value in column with 2 criteria 1
Try to be more precise 4
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
Conditional formatting based on formula cell 6
Figuring out a lengthy formula. Probably quite simple... 3

Top