summing user specified cells

J

JMSatMetro

I have a worksheet with data arranged in columns, where column headers are
months/years.

I want to be able to use user-input "begin" and "end" dates, and allow
columns in a specified row to be summed, which match these dates.

How to accomplish this?
 
E

excelent

=SUMPRODUCT((A1:Z1>=DATE(2007,1,3))*(A1:Z1<=DATE(2007,1,6))*(A2:N2))
Sum's Mar,Apr,May,Jun


"JMSatMetro" skrev:
 
E

excelent

=SUMPRODUCT((A1:Z1>=DATE(2007,1,3))*(A1:Z1<=DATE(2007,1,6))*(A3:N5))
sum row 3 to 5


"excelent" skrev:
 
Top