SOLVED

# Error being returned summing field

Brass Contributor

# 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

best response confirmed by packie (Brass Contributor)
Solution

# Re: Error being returned summing field

That could be

``=SUMIFS( Sheet1!\$O\$5:\$O\$1000, Sheet1!\$O\$5:\$O\$1000, ">0", Sheet1!\$R\$5:\$R\$1000, D24 )``
1 best response

Accepted Solutions
best response confirmed by packie (Brass Contributor)
Solution

# Re: Error being returned summing field

That could be

``=SUMIFS( Sheet1!\$O\$5:\$O\$1000, Sheet1!\$O\$5:\$O\$1000, ">0", Sheet1!\$R\$5:\$R\$1000, D24 )``