I am looking for help on how to create a formula. I want the formula to add up two columns on sheet 2, if it falls in between two date ranges and matches text "Example1" in sheet 1.
Better to upload a sample file for proper understand. We will help you with the formula depends upon your input and expected output in the sample file.