i need a number total derived from words

G

greenlion

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

Ian P

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
 
A

Ardus Petus

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

HTH
--
AP

Ian P said:
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
Click to expand...
 
G

greenlion

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