Subject: Count and Sum Multiple Conditions in one column
great- thanks!
So if in the last column, I do NOT want it to include 'dropped' or blank
cells- how do I indicate that? I tried doing the following but it is only
reading the 'dropped' and ignoring my request to eliminate the count if it is
blank cell in N.
=SUMPRODUCT(--(D2:D16="Red"),--(E2:E16=0),--(N2:N16<{"dropped",""}))
Am I using the wrong symbols to indicate a blank cell? Or is it impossible
to do more than one 'does not include' (<)contingency?
Thanks again!
|