I have the following formula which works nicely but, I only want it to count the non blanks in range BX3:BX1003 when it is blank in range AX3:AX1003.
=SUMPRODUCT((((Properties!$Q$3:$Q$1002="Y")+(Properties!$Q$3:$Q$1002="A"))*(MONTH(Properties!$DV$3:$DV$1002)=MONTH(Months!$A3))*(Properties!$DV$3:$DV$1002<>""))*(Properties!$BX$3:$BX$1002<>""))
Tried the following which for some reason doesn't work;
=SUMPRODUCT((((Properties!$Q$3:$Q$1002="Y")+(Properties!$Q$3:$Q$1002="A"))*(MONTH(Properties!$DV$3:$DV$1002)=MONTH(Months!$A3))*(Properties!$DV$3:$DV$1002<>""))*(OR(Properties!$AX$3:$AX$1002<>"",Properties!$BX$3:$BX$1002<>"")))
Any Help would be much appreciated
Bookmarks