Add date range to SUMPRODUCT formula

[GraeT]

Hi and thanks to all in advance

I am trying to create a formula to calculate the $ total of my employees work via a few variables. At present I have a working formula that calculates each individual employees $ total;

=SUMPRODUCT((C1:C24999=service type)*(V1:V$24999=Practitioner name)*K1:K24999)​

C column = Service type
With V column = Practitioner Name
K column = The cost of each service (which can vary as some people get discounts etc)

Each entry in the spreadsheet is dated and I have the start and finish dates of the range in separate cells. I have tried multiple variations on the above formula to include a date range but I cannot get it to work.

If you have some advice it would be much appreciated

Cheers

 

[oldbrewer]

assume start date in A column and end date in B column

=sumproduct((......)*(.....)*(A1:a100>$t$1-1)*(A1:a100<$w$1+1))

t1 = chosen start date w1 = chosen end date