Sum if the same cell contains two answers

Samuel Dowdy Jr.

=SUMIFS({MASTER - Payroll Entry Log Sheet Range 1}, {MASTER - Payroll Entry Log Sheet Range 4}, [0005 - Revenue Earned]7, OR([005A - Revenue Earned]7))

What am I doing wrong?

Kelly Moore

Hey @Samuel Dowdy Jr

Just a minor tweak to get it working. The OR is out of place.

=SUMIFS({MASTER - Payroll Entry Log Sheet Range 1}, {MASTER - Payroll Entry Log Sheet Range 4}, OR([0005 - Revenue Earned]7, [005A - Revenue Earned]7))

Unless you need to call out row 7 specifically, I strongly encourage you to use @row in place of 7

=SUMIFS({MASTER - Payroll Entry Log Sheet Range 1}, {MASTER - Payroll Entry Log Sheet Range 4}, OR([0005 - Revenue Earned]@row, [005A - Revenue Earned]@row))

https://help.smartsheet.com/function/or

cheers,

Samuel Dowdy Jr.

=SUMIFS({MASTER - Payroll Entry Log Sheet Range 1}, {MASTER - Payroll Entry Log Sheet Range 4}, OR("005A - Service (San Antonio)", "0005 - Service"))

This is what I'm using and Im geting an invalid operation. Can you help?