=SUM(COUNTIFS($G$4:$O$4,{"Chargeback","pending response","Pending Other","High","Med","X"}))+SUM(COUNTIFS($B$4:$E$4,{"Chargeback","pending response","Pending Other","High","Med","X"}))
=SUM(COUNTIFS($G$4:$O$4,{"Chargeback","pending response","Pending Other","High","Med","X"}))+SUM(COUNTIFS($B$4:$E$4,{"Chargeback","pending response","Pending Other","High","Med","X"}))
Peace of mind is found in some of the strangest places.
If you're certain that column F (or specifically cell F4) can never contain one of those things you're counting then:
=SUM(COUNTIFS($B$4:$O$4,{"Chargeback","pending response","Pending Other","High","Med","X"}))
Separately, you could also refer to a named range containing those strings (Chargeback etc.) but you'd have to commit the formula to the sheet using Ctrl+Shift+Enter, not just Enter:
=SUM(COUNTIFS($G$4:$O$4,Stuff))+SUM(COUNTIFS($B$4:$E$4,Stuff))
p45cal
Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
thanks
Peace of mind is found in some of the strangest places.
Shorter than the original, but less readable IMO:
=SUMPRODUCT(($B$4:$O$4={"Chargeback";"pending response";"Pending Other";"High";"Med";"X"})*(COLUMN($B$4:$O$4)<>6))
Be as you wish to seem