When I first made this chart last year I was given a SUMProduct formula that
looks like it had me say "sumproduct (keyboard cell does not contain words
meaning that the station is not broken0,(monitor cell does not contain one of
the words meaning that the station is not broken)

"FormulaQuestioner" wrote:

Will that work if one row has multiple problems with it. I am doing a count
where I want it to say that there is 1 broken station even if there is
multiple broken equipment there.

"Matt Richardson" wrote:

On Jan 29, 9:10 am, "Bob Phillips" wrote:
=SUM(COUNTIF(A1:Z50,{"Monitor Broken","Computer No Power","USB Mouse
Missing"}))

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"FormulaQuestioner" wrote in
...

I am currently working on an inventory spreadsheet.

Each row will represent one desk. Each column will be used for a piece of
equipment.

In this spreadsheet each piece of equipment have have things wrong with
them
that will make the station count as not working, but some of the entires
will
not count towards that.

I would like a formula that I can use in a cell that will count all of the
rows and this is the criteria

problem stations
=all of the cells that have at least one of the following criteris (ie
Montior Broken, Computer no power, USB Mouse Missing)

I did have a formula before that was kind of like that but when ever a
field
would have something in it that did not fall into that category it would
not
could the station is having a problem

Any help would be appreciated

Ignore my earlier response to this - I was having a dumb moment!!

OzGrid has a few other alternatives which can be useful too:-

http://www.ozgrid.com/Excel/count-if.htm

Regards,
Matt Richardson
http://teachr.blogspot.com