I have a formula being used in ms2007
=COUNTIFS(ALL_OPEN!M:M,"",ALL_OPEN!Q:Q,"<=14"). The answer I receive is 1007, which is the correct answer.
Countifs does not work in ms2003; therefore, I am trying to use
=SUMPRODUCT(--(ALL_OPEN!$M$2:$M$10000=""),--(ALL_OPEN!$Q$2:$Q$10000<=14)) in its place. The answer I receive for the sumproduct formula is 3718, which is wrong.
What am I doing wrong???
=COUNTIFS(ALL_OPEN!M:M,"",ALL_OPEN!Q:Q,"<=14"). The answer I receive is 1007, which is the correct answer.
Countifs does not work in ms2003; therefore, I am trying to use
=SUMPRODUCT(--(ALL_OPEN!$M$2:$M$10000=""),--(ALL_OPEN!$Q$2:$Q$10000<=14)) in its place. The answer I receive for the sumproduct formula is 3718, which is wrong.
What am I doing wrong???