ExcelBanter - summing user specified cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - summing user specified cells (https://www.excelbanter.com/excel-discussion-misc-queries/141487-summing-user-specified-cells.html)

JMSatMetro

summing user specified cells

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?

excelent

summing user specified cells

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

"JMSatMetro" skrev:

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?

excelent

summing user specified cells

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

"excelent" skrev:

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

"JMSatMetro" skrev:

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?

All times are GMT +1. The time now is 12:40 PM.