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

Samuel Dowdy Jr.

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

Mark Cronk

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

Samuel Dowdy Jr.

=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