Sumproduct: Incorporating date

[prazad82]

How do i do a sumproduct between a prefixed dates?


Beginnig date: 6 May

End Date: 12 May


This is my formula


=SUMPRODUCT((Tracker!$K$5:$K$241=Plan!$C5)*(Tracker!$D$5:$D$241=Plan!$N$4))


How do I get the result within the above range, with the start and end dates?


Please help

 

[Hui]

Prazad82


Assuming the Begining date is in B2

Assuming the Ending date is in B3

=SUMPRODUCT((Tracker!$K$5:$K$241=Plan!$C5)*(Tracker!$D$5:$D$241=Plan!$N$4)*(DateRange>B2)*(DateRange<B3))


to include the dates in the range

=SUMPRODUCT((Tracker!$K$5:$K$241=Plan!$C5)*(Tracker!$D$5:$D$241=Plan!$N$4)*(DateRange>=B2)*(DateRange<=B3))

 

[prazad82]

Excellent! thank you very much