I can't figure this one out and need help. Sheet1 has names in col 1 and
values in col 2 -

I want to add totals together for everytime a certain name is found in col 1
in the sheet 2. (Name is listed multiple times on sheet 1)

This is easy but I can't remember how to do it!

Thanks for any help provided.

Annette

=SUMIF(Sheet1!A1:A20,A1,Sheet1!B1:B20)

A1 = the Name you want totals for.

HTH,
Paul


--

"Annette" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
>I can't figure this one out and need help. Sheet1 has names in col 1 and
>values in col 2 -
>
> I want to add totals together for everytime a certain name is found in col
> 1 in the sheet 2. (Name is listed multiple times on sheet 1)
>
> This is easy but I can't remember how to do it!
>
> Thanks for any help provided.
>
> Annette
>

THAL (this helps a lot!) Thanks!

"PCLIVE" <pclive(RemoveThis)@cox.net> wrote in message
news:(E-Mail Removed)...
> =SUMIF(Sheet1!A1:A20,A1,Sheet1!B1:B20)
>
> A1 = the Name you want totals for.
>
> HTH,
> Paul
>
>
> --
>
> "Annette" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
>>I can't figure this one out and need help. Sheet1 has names in col 1 and
>>values in col 2 -
>>
>> I want to add totals together for everytime a certain name is found in
>> col 1 in the sheet 2. (Name is listed multiple times on sheet 1)
>>
>> This is easy but I can't remember how to do it!
>>
>> Thanks for any help provided.
>>
>> Annette
>>
>
>