Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Countif cell if other cells match criteria | Excel Worksheet Functions | |||
MATCH Multiple Criteria & Return Previous / Penultimate Match | Excel Worksheet Functions | |||
match multiple criteria ina range from multiple criteria multiplet | Excel Worksheet Functions | |||
Counting cells that match 2 criteria | Excel Discussion (Misc queries) | |||
Fill cells if adjacent cell match criteria | Excel Discussion (Misc queries) |