View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
FormulaQuestioner FormulaQuestioner is offline
external usenet poster
 
Posts: 29
Default Countcells if they match certain criteria from other cells

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

Criteria

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

For the real table the ranges are much larger, I just put them as small
numbers for less typing.