Assume data in row2 down, where col A = desk#
and "broken ... " could appear in either cols B, C or D

Place in E2:
= --(SUMPRODUCT(--(ISNUMBER(SEARCH("broken",B2:D2))))0)
Copy down to the last row. Col E will return a "1" or zero depending on
whether "broken" was found in either cols B, C or D for each desk.

Then you could get a running total of the broken desks
by placing in F2: =SUM($E$2:E2)
and copy F2 down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"FormulaQuestioner" wrote:
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.