Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #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
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 622
Default Adding duplicates...

I'm hoping to not also have to use a formula indicating a name in there, if that makes sense:

The above quote concerns me. Do you have the name's listed in this
summary area as a row/column label? The formula could simply reference
this label rather than having the name right in the formula. Maybe
that's what you mean.

Say, this is in E1:
=SUMPRODUCT(--(A1:A100=D1)*B1:B100)

Where D1 is the label "Janet" or "Jon" or whatever. The A column range
can just include the entire length of data, it doesn't matter if some
are blank or month names or whatever.
Reply
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 11:35 PM.

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"