Skip to main content
Support is Offline
Today is our off day. We are taking some rest and will come back stronger tomorrow
Official support hours
Monday To Friday
From 09:00 To 17:30
  Sunday, 12 August 2018
  0 Replies
  6.9K Visits
0
Votes
Undo
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)))
There are no replies made for this post yet.