SUMIF

  • Thread starter Thread starter Orange Fuel
  • Start date Start date
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.
 
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)
 
Back
Top