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 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!