sum of a column on condition

H

Hamsa

How do I sum the contents of a column where the column is determined by the
current month?
 
C

Chris Bode via OfficeKB.com

A1:A10 contain date
in C1:C10 add following formula
=MONTH(A1)
in D1:D10 add following formula
=SUMIF(C1:C10,MONTH(TODAY()),B1:B10)

Chris
 
H

Hamsa

Chris Bode via OfficeKB.com said:
A1:A10 contain date
in C1:C10 add following formula
=MONTH(A1)
in D1:D10 add following formula
=SUMIF(C1:C10,MONTH(TODAY()),B1:B10)

Chris
------
Click to expand...

Some more detail on my question:
Columns A to L represent Jan to Dec months
Based on the current month, Sum of the entries in the corresponding column
are needed in another worksheet which is used every month to project the
details of that month only
The column hence needs to be determined by the current month
 
Top