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?

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


"greenlion" wrote:

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'd rather use COUNTIF(A1:A50,"IP")

HTH
--
AP

"Ian P" a écrit dans le message de news:
...
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


"greenlion" wrote:

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?

your solution worked. thanks!!

"Ardus Petus" wrote:

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

HTH
--
AP

"Ian P" a écrit dans le message de news:
...
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


"greenlion" wrote:

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?

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

"Ian P" wrote:

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


"greenlion" wrote:

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?