Adding duplicates...

[accountant]

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

 

[Spiky]

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.