Hi,
I have a spreadsheet and use formula below to add sales from our depots by product types. Depot is is column and product type is in row. It all works fine but I want to add in a date criteria (for example I want all sales from 1/7/18 - 6/7/18) to the formula (below). thank you.
=+SUMIF('2018 Summary'!$A$2:$A$2549,Dashboard!$C$8,INDEX('2018 Summary'!$F$2:$JX$2,MATCH(Dashboard!$G$10,'2018 Summary'!$F$1:$JX$1,0)))
I have a spreadsheet and use formula below to add sales from our depots by product types. Depot is is column and product type is in row. It all works fine but I want to add in a date criteria (for example I want all sales from 1/7/18 - 6/7/18) to the formula (below). thank you.
=+SUMIF('2018 Summary'!$A$2:$A$2549,Dashboard!$C$8,INDEX('2018 Summary'!$F$2:$JX$2,MATCH(Dashboard!$G$10,'2018 Summary'!$F$1:$JX$1,0)))