A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Adding duplicates...



 
 
Thread Tools Display Modes
  #1  
Old July 23rd, 2008, 06:05 PM posted to microsoft.public.excel.worksheet.functions
Accountant
external usenet poster
 
Posts: 11
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  
Old July 23rd, 2008, 10:40 PM posted to microsoft.public.excel.worksheet.functions
Spiky
external usenet poster
 
Posts: 619
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.
 




Thread Tools
Display Modes

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

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:26 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.