LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5
Default Adding duplicates...

I need help figuring out a formula to add duplicates as follows:

I have 3 months of figures with duplicate names on each month. I need to
add these amounts to a quarterly sheet. I want the names on the quarterly
sheet to show once, and with the totals for the 3 months. I'm hoping to not
also have to use a formula indicating a name in there, if that makes sense:

i.e
January;

Janet 5
Carol 10

February:
Bill 4
Janet 8

March:
Jon 11
Carol 14

Quarterly:
Janet 13
Carol 24
Bill 4
Jon 11
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Duplicates in excel that aren't 100% DUPLICATES ... [email protected] Excel Discussion (Misc queries) 4 May 2nd 08 06:43 PM
Duplicates help Matt Excel Discussion (Misc queries) 0 September 14th 07 02:00 PM
Duplicates Karen[_2_] Excel Worksheet Functions 4 April 18th 07 03:29 PM
Adding new numbers as I type without duplicates from Sheet1,ColumnA to Sheet2,ColumnA Master Excel Worksheet Functions 2 July 12th 05 05:03 PM
Duplicates Alex Excel Discussion (Misc queries) 0 May 20th 05 07:22 PM


All times are GMT +1. The time now is 09:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"