Modify this formula so that it also looks at the Date column

[gheyman]

I have this formula that I am using so that it works dynamically with filters (only sums filtered values). In this same table, that it is referencing, I have a filed named "Date"

I want to put a Start date in cell O3 and an End Date in P3 and have the formula only sum if the Date field is equal to or between those dates. Any help is appreciated.


=SUMPRODUCT((ProjHoursActuals[ProjectLaborCategoryCode]=O5)+0,SUBTOTAL(109,OFFSET(ProjHoursActuals[Value],ROW(ProjHoursActuals[Value])-MIN(ROW(ProjHoursActuals[Value])),0,1,1)))

 

[Fluff]

How about

=SUM(FILTER(ProjHoursActuals[Value],(ProjHoursActuals[ProjectLaborCategoryCode]=O5)*(ProjHoursActuals[Date]>=O3)*(ProjHoursActuals[Date]<=P3)*(MAP(ProjHoursActuals[Value],LAMBDA(m,SUBTOTAL(106,m))))))