Sorry,

I obviously clicked the wrong posting prior to typing the previous posting.
It obviously has nothing at all to do with it.

--

Regards
Roger Govier

"Roger Govier" <roger@technology4unospamdotcodotuk wrote in message
...
Hi
Try
=COUNTIF(A2:H2,<"")1

Change the range A2:H2 to suit.
Copy down as far as required.
Filter on column with formula=TRUE to find rows which match


--

Regards
Roger Govier

"FormulaQuestioner" wrote in
message ...
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.