I have been playing around with the countif statements and am trying to
figure out a few forumlas which I can not see to code:

Arguments:

Checking the cells c6:f6 if any of the cells have the words "Missing"
"Broken" "* Missing" "No Power" "Liscense" "Needs to be reflashed" "Not on
Network" cell is 0, if not then cell is 1

Count the cells from c6:c7 if the cell is blank and (e6:e7 or f6:f7 does not
say "Not on Network")

Count the cells from e6:e7 if cell has the word ("Missing" or "Broken") and
(e6:e7 or f6:f7 does not say "Not on Network")

Count the cells from d6:d7 if cell has the word "PS 2" and (e6:e7 or f6:f7
does not say "Not on Network") *I think that this could just be the same
formula for the one where it checks for blank, but if I am wrong I added this*

Any help would be appreciated

Ah, darned, you multi-posted (you shouldn't, you know)
You've got a response to the 1st question in your multi-post in
..worksheet.functions.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Sorry abou that. At first I thought when I tried to post and it didnt work.
Turns out I posted under the wrong cateogry.

"Max" wrote:

Ah, darned, you multi-posted (you shouldn't, you know)
You've got a response to the 1st question in your multi-post in
..worksheet.functions.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---