Countcells if they match certain criteria from other cells
Thank-you
"Pete_UK" wrote:
Use COUNTIF when you only have one criteria. Where you have more, then
use SUMPRODUCT, like this:
=SUMPRODUCT((D6:D10="PS 2")*(E6:E10<"Not on Network"))
I've made the ranges a bit bigger - they should be equal in size, but
cannot be a full column (unless you have XL2007).
Hope this helps.
Pete
On Feb 12, 12:26 am, FormulaQuestioner
wrote:
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.
|