Hi folks,
In the following formula:
=SUMIFS((Sheet1!$R$5:$R$1000, D24)=SUMIF(Sheet1!$O$5:$O$1000,">0"))
colR is the week number
D24 refers to week number 19
colO is the amount sold
The formula I am trying looks first to find the matching field number and then sum the the total of colO where the amount of each week number found is greater than 0
For example D24 has found three week 19's in colO two of the records are greater than 0 and one record less than 0
The formula should only sum those records that are greater than 0
Thank you for your interest!
