How do I sum something when I'm looking for multiple names in a cell

Options

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

Answers

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    Options

    Try:

    =SUMIFS({MASTER - Payroll Entry Log Sheet Range 1}, {MASTER - Payroll Entry Log Sheet Range 2}, AND(HAS(@cell, "005 - Service", HAS(@cell, "005A - Service (San Antonio)")))

    I assume that range 2 is a multiselect column.

    Work?

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

  • Samuel Dowdy Jr.
    Samuel Dowdy Jr. ✭✭✭✭✭✭
    Options

    =SUMIFS({MASTER - Payroll Entry Log Sheet Range 1}, {MASTER - Payroll Entry Log Sheet Range 2}, Year@row, {MASTER - Payroll Entry Log Sheet Range 3}, $Data8, {MASTER - Payroll Entry Log Sheet Range 4}, AND(HAS(@cell, "0005 - Service", HAS(@cell, "005A - Service (San Antonio)"))))


    Its not working

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!