Hello,
I am just wondering if this formula I've done could have been written in a different or better way.
=SUMPRODUCT(--((A1>=0)*(A1<=4))+SUMPRODUCT(--((A2>=0)*(A2<=4))+SUMPRODUCT(--((A3>=0)*(A3<=4))+SUMPRODUCT(--((A4>=5)*(A4<=9))+SUMPRODUCT(--((A5>=5)*(A4<=9))+SUMPRODUCT(--((A6>=5)*(A6<=9))+SUMPRODUCT(--((A7>=5)*(A4<=9)))))))))
Thank you
Sans
Bookmarks