Countif Cell multiple arguments

  • Thread starter FormulaQuestioner
  • Start date
F

FormulaQuestioner

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
 
M

Max

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.
 
F

FormulaQuestioner

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top