i need a number total derived from words

[Guest]

for instance, I have 6 sales people who will be adding their own info into a
shared spreadsheet that I created and one column is designated for their
1st/last inititals of their name. i need a number total for each of these
salespeople derived from their initials. does this make sense?

 

[Guest]

Try:

=sumif(A1:A50,"IP") to sum all of IPs. This assumes your list of names is
in A1:A50 and you will get given the total number of times IP has entered
their initials.

HTH

Ian

 

[Ardus Petus]

I'd rather use COUNTIF(A1:A50,"IP")

HTH
--
AP

Try:

=sumif(A1:A50,"IP") to sum all of IPs. This assumes your list of names is
in A1:A50 and you will get given the total number of times IP has entered
their initials.

HTH

Ian

 

[Guest]

thanks!! i'll try both your's and Ardus' formulas to see which works best
for me.

 

[Guest]

your solution worked. thanks!!

I'd rather use COUNTIF(A1:A50,"IP")

HTH