Conditional Sum

  • Thread starter Thread starter Bruce
  • Start date Start date
B

Bruce

I need to figure out a way to sum a column of numbers between two dates.

For instance, I have a column with every date in the year. Next to each
date I have a value.


Jan 1 9
Jan 2 3
Jan 3 4
Jan 4 7
etc

I would like to be able to enter two dates and have the values added up
between those dates. Such as Jan 2 and Jan 4 and get the result 14.

Can anybody point me in the right direction?

Bruce
 
=SUMPRODUCT(--(Date_Range>=date1),--(Date_Range<=date2),Value_Range)

note that this will only work if the dates are real excel dates (numeric),
will not work for text
 
Back
Top