formula needed for multiple cells based on date range

[excelteam777]

WS attached

(Dashboard) J6 = Formula
On “Dashboard”, when a start date(G1) /end date(G2) is entered,
Formula will return based on that date range from “MAIN” B3:B17,
And multiply the number in”MAIN” N3:N17 by the number listed in “MAIN” AD3:AD17

[Pete_UK]

You can use this formula in cell J6 of the Dashboard sheet:

=SUMPRODUCT((MAIN!$B$3:$B$17>=$G$1)*(MAIN!$B$3:$B$17<=$G$2),MAIN!$N$3:$N$17,MAIN!$AD$3:$AD$17)

Hope this helps.

Pete

[excelteam777]

yes works great, thank you so much

[Pete_UK]

That's good to hear - thanks for feeding back, and thanks for the rep.

Pete