Hi, last week I was trying to make a report that shows the sales evolution by weeks and months at the same time (example: January: week 1, week 2, week3, week 4 -and the same for other months-). When researching I read that excel is not able to show the information that way. Is that true? Does somebody knows how to do this?
So that EXCEL can understand the period within which you want to return the Total Sales, you must specify the start date and end date of the week you are referring to. For example, if your Dates are in A2:A100, your Sales are in B2:B100, and you want to return the Total Sales for week 1 of January 2019, you must specify the start date (1/1/2019 in F2) and the end date (1/7/2019 in G2), so that your formula should look like this: =SUMIFS(B2:B100,A2:A100,">="&F2,A2:A100,"<="&G2)