# Sumproduct Question User Enters Date Range in Data Validation Cells

1. ## Sumproduct Question User Enters Date Range in Data Validation Cells

I have a spreadsheet that has multiple colums. The columns are a date, a code and a number. I want to pull the totals based on a criteria where the user enters dates in
2 Data Validation Date cells. So as the user enters date ranges the Totals will change based on the range in the Sumproduct formula.

=SUMPRODUCT('S-90-E (2)'!A10:A656>=DATEVALUE(I14))--('S-90-E (2)'!A\$10:A\$656<=DATEVALUE(J14))--('S-90-E (2)'!M\$10:M\$653)--('S-90-E (2)'!B\$10:B\$653='S-124'!H30)

I created an example sworkbook that has the data and a formula similiar to the one above......

Thanks!

2. ## Re: Sumproduct Question User Enters Date Range in Data Validation Cells

SUMIFS:

=SUMIFS(data!\$C\$2:\$C\$13,data!\$A\$2:\$A\$13,">="&E2,data!\$A\$2:\$A\$13,"<="&F2)

SUMPRODUCT:

=SUMPRODUCT(--(data!\$A\$2:\$A\$13>=E2),--(data!\$A\$2:\$A\$13<=F2)*(data!\$C\$2:\$C\$13))

3. ## Re: Sumproduct Question User Enters Date Range in Data Validation Cells

either:

``Please Login or Register  to view this content.``
or

``Please Login or Register  to view this content.``
avoid explicit coercion of "summation range" unless required explicitly (i.e. mimic SUMIF) and/or by virtue of array dimensions

There are currently 1 users browsing this thread. (0 members and 1 guests)