Need help adding money from one column with different criteria from another column

Wanda Jackson

I'm trying to add a sub-total column ($) that is greater than $0.00 for items that are approved in another column, but keep getting either "Incorrect" or Unparseable" errors. Can someone help with this formula?

Thanks,

Wanda Jackson

Kelly Moore

Try this

=SUMIFS([sub total]:[sub total], [sub total]:[sub total], >0, [Approval]:[Approval], "Approved")

Please be sure to change column names to match yours

cheers

Wanda Jackson

Thank you. I did not have that 2nd [sub total]:[sub total] in my equation.

Wanda J.

Kelly Moore

Try this

=SUMIFS([sub total]:[sub total], [sub total]:[sub total], >0, [Approval]:[Approval], "Approved")

Please be sure to change column names to match yours

cheers

Wanda Jackson

Thank you. I did not have that 2nd [sub total]:[sub total] in my equation.

Wanda J.

Kelly Moore

SUMIFs have the syntax of Range, criteria range1, criteria1, criteria range2, criteria 2, etc so it’s an easy piece to miss when the sum range and criteria range is the same. Glad it worked