Sum if the same cell contains two answers

=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?

Answers

  • Kelly Moore
    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))

    cheers,

  • Samuel Dowdy Jr.
    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?

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!