Forum Discussion
Solved
Error being returned summing field
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...
That could be
=SUMIFS( Sheet1!$O$5:$O$1000, Sheet1!$O$5:$O$1000, ">0", Sheet1!$R$5:$R$1000, D24 )
That could be
=SUMIFS( Sheet1!$O$5:$O$1000, Sheet1!$O$5:$O$1000, ">0", Sheet1!$R$5:$R$1000, D24 )