Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Duplicates in excel that aren't 100% DUPLICATES ... | Excel Discussion (Misc queries) | |||
Duplicates help | Excel Discussion (Misc queries) | |||
Duplicates | Excel Worksheet Functions | |||
Adding new numbers as I type without duplicates from Sheet1,ColumnA to Sheet2,ColumnA | Excel Worksheet Functions | |||
Duplicates | Excel Discussion (Misc queries) |