View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
melisa0820 melisa0820 is offline
external usenet poster
 
Posts: 2
Default Help adding letters in column

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???