Help adding letters in column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i need help...

i have a sheet that looks like this for example

apples p
pears v
banana p
cherry p
grapefruit v

my questions is - is there a formula that i can use to add up the "p's" in a
specific column with out counting them manually???
 
hi,
are the values (fruits and letters) in the same column?
if so example 1 - same column in column A...
=countif(A1:A100,"*p")

if not exaple 2 - different columns -fruits column A, letters column B...
=countif(B1:B100,"p")

Adjust to your data.
Regards
FSt1
 
Back
Top