PC Review


Reply
Thread Tools Rate Thread

Adding like occurences

 
 
Annette
Guest
Posts: n/a
 
      11th Mar 2008
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


 
Reply With Quote
 
 
 
 
PCLIVE
Guest
Posts: n/a
 
      11th Mar 2008
=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
>



 
Reply With Quote
 
Annette
Guest
Posts: n/a
 
      11th Mar 2008
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
>>

>
>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Finding occurences of a given value in a row PhillyD Microsoft Excel Misc 0 6th Feb 2009 07:12 PM
Re: Count # of Occurences T. Valko Microsoft Excel Misc 1 14th Dec 2006 02:27 AM
Re: Count # of Occurences Nick Hodge Microsoft Excel Misc 1 13th Dec 2006 11:08 PM
First Occurences ExcelMonkey Microsoft Excel Discussion 2 5th Oct 2004 06:58 PM
First Occurences ExcelMonkey Microsoft Excel Discussion 1 5th Oct 2004 01:46 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:42 AM.