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

Help adding letters in column
 

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

"melisa0820" wrote:

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

Help adding letters in column
 

=COUNTIF(A1:A100,"P")


"melisa0820" wrote:

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