Forum Discussion
Solved
Sum total sold for each week
Hi, Sheet1 Q5:Q1000 contains a value of between 1 and 52. The numbers represent week numbers. O5:O1000 contains a value which is the quantity of a given item. Sheet2 D5:D56 contain the val...
In F5 on Sheet2:
=SUMIFS('Sheet1'!$O$5:$O$1000, 'Sheet1'!$Q$5:$Q$1000, D5)
Replace Sheet1 with the real name of that sheet, if necessary.
Fill down to F56.
In F5 on Sheet2:
=SUMIFS('Sheet1'!$O$5:$O$1000, 'Sheet1'!$Q$5:$Q$1000, D5)
Replace Sheet1 with the real name of that sheet, if necessary.
Fill down to F56.