[Solved] Add a Criteria to my Formula

[Jululian]

Dear All,​

Many Thanks on your help and support​

is it possible to add a Criteria to my Formula in H9 to include date​

Many Thanks​

 

[Bishawajit]

Dear Jululian,
Thank you for your question.
Here is the solution to your problem. Please check this properly.

Based on your provided date range, you can modify the formula to include the specific date criteria. Here's the modified formula:

=SUMPRODUCT(--(MOD(B7:B172,1)>=F6),--(MOD(B7:B172,1)<=H6),--(A7:A172>=DATEVALUE("2023-02-09")),--(A7:A172<=DATEVALUE("2023-08-26")),D7:D172)

I have attached the file so that you can easily understand it.

Thank you so much.