Count cells with a certain value

[milehighpgmr]

Good afternoon

I'm new to the forum and I'm really hoping someone can help me with this programming issue. I have a spreadsheet that has a name in the first cell, and the following 15-20 cells (on the same row) can have either a 'P', 'E', 'U', ' '. What I would like to do is have 4 additional columns on the right side that have the count for each value. For example, if there were 5 "P"s on the row, the total for "P"s would display a value of 5.

I've tried COUNT, COUNTIF, and I know I'm probably just not coding it properly.

Any help would be greatly appreciated!

Thanks
Chris

[arthurbr]

Say your range is A2 :A10 , try =countif(a2:a10,"p")

[whatsmyname]

Say your range is A2 :A10 , try =countif(a2:a10,"p")

You would just type this formula into the cell that you wish to have accumulate the totals!!