SUMIF

O

Orange Fuel

I have two columns. First column contains dates, second column contains
numbers. I want to sum all numbers for a specific month and year (i.e. sum
all cells with date of 12-2009)

Thanks.
 
T

T. Valko

One way...

Use cells to hold the dates of your boundaries.

D1 = lower date boundary = 12/1/2009
E1 = upper date boundary = 12/31/2009

Column A contains the dates
Column B contains the values to sum

=SUMIF(A1:A20,">="&D1,B1:B20)-SUMIF(A1:A20,">"&E1,B1:B20)
 

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

Top