sum of a column on condition

  • Thread starter Thread starter Hamsa
  • Start date Start date
H

Hamsa

How do I sum the contents of a column where the column is determined by the
current month?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Numbers showing Up Centered in Cell ? 1
Conditional SUBTOTAL in XL210 Table 7
How to copy a conditional sum, but change the column 5
Filtering with SUMIFS 1
Sumif formula 4
SUMIF with NAME RANGE 1
Copy paste data from a column to a row 0
conditional formula question with multiple criteria 2

Back
Top