SUMPRODUCT excluding blank cells

[mmac723]

I'm trying to count how many agents hit goal in a particular quarter.
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

 

[DanteAmor]

Try this

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

 

[mmac723]

Unfortunately that came back with the value "-319". I added spaces between the " " and came back with the value 1202.
The answer for the particular set I'm working with should be 5.

Any ideas what's going on??

 

[DanteAmor]

You could copy the excel data with which you are testing and paste it here, to review them.

 

[mmac723]

I got it to work!!
Thank you so much!

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.