i need a number total derived from words

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

[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


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

[Ardus Petus]

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

HTH
--
AP

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

[greenlion]

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?

[greenlion]

your solution worked. thanks!!

"Ardus Petus" wrote:

> I'd rather use COUNTIF(A1:A50,"IP")
>
> HTH
> --
> AP
>
> "Ian P" <[email protected]> a écrit dans le message de news:
> [email protected]...
> > 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?
>
>
>