Subtotals by Year?

  • Thread starter Thread starter Guest3731
  • Start date Start date
G

Guest3731

Hi - here's the scenario:

Column A is a person's name.
Column B is a date, e.g., 4/1/1979.
Column C is an amount of money.

I'd like to subtotal this spreadsheet by date - but not by individual
day, rather by year - i.e. I would like one subtotal for 1979, another
for 1980, etc.

Is this achievable?

Thanks very much.
 
Hi,

And another variation

=SUMPRODUCT(--(A$1:A$100=D1),--(YEAR(B$1:B$100)=E1),C$1:C$100)

where you enter the persons name in D1 and the year in E1. The advantage in
using cell references for the D1 & E1 is that you can set up a table rather
quickly and just copy the formula down.

If this helps, please click the Yes button

Cheers,
Shane Devenshire
 
Back
Top