I've set up the following formula to see if the number in column B is greater than that in column H, subtracting if LOA is entered.

My problem is it's counting blank spaces, totally throwing off my calculations, and I can't seem to get it to stop!

=(SUMPRODUCT(--(B3:B15>=H3:H15))+SUMPRODUCT(--(B17:B29>=H17:H29)) +SUMPRODUCT(--(B31:B43>=H31:H43)))-SUMPRODUCT(--(B3:B43="LOA"))-SUMPRODUCT(--(B3:B43="Pending"))

HELP!!

thank you, mmac