I am working on a spreadsheet to keep track of working and non working desks
in an office.

Each desk has 1 row, each piece of equipment has their own column.

I want to have a formula where it will count a station is it has one of the
following "broken usb keyboard" or "broken usb keyboard" or "broken phone" or
"broken monitor". If a station has 2 things broken I want it only counted
once.

Can someone please help me with a formula.