COUNTIF based on several criteria incl. a "does not equal" criteri
I am trying to create a formula that will count the total number of cells
that meet multiple criteria, including a "does not equal" criteria.
Basically, I am trying to count the total number of cells that meet the
following:
Column O = "ROH"
Column H is "Not" blank, and
Column J = 1/5/2008
I have tried the following SumProduct formula, but it is not yielding the
correct result:
=SUMPRODUCT((H2:H350<" "),(J2:J350="1/5/2008"),(O2:O350="ROH"))
For whatever reason, I am getting a "0" result when I know there should be
at least 7. What am I doing wrong?!!!
|