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!
Bookmarks