If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|