I am newbie in using Excel functions. I have an excel file as shown in the following screenshot. I used following formula for getting total sale amounts for the sale happened between 02/01/2019 and 06/30/2019. It works fine
=SUMIFS(D2:D6,C2:C6,">=" & F3, C2:C6,"<=" & G3)
I need to improve the logic to get total same amount for each category for the sale happened between 02/01/2019 and 06/30/2019. How to do it?
Note: I need to make this as a utility where other users will just update the values in column
G3. So, I cannot use