J Jululian Member Jun 12, 2023 #1 Dear All,Many Thanks on your help and supportis it possible to add a Criteria to my Formula in H9 to include dateMany Thanks Attachments Formula Creteria.xlsx Formula Creteria.xlsx 221.8 KB · Views: 4
Dear All,Many Thanks on your help and supportis it possible to add a Criteria to my Formula in H9 to include dateMany Thanks
B Bishawajit New member Support Staff Jun 19, 2023 #2 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: Code: =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. Attachments Formula Creteria.xlsx Formula Creteria.xlsx 220.8 KB · Views: 4 Last edited: Jun 19, 2023
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: Code: =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.