omitting blank cells

I did this formula as suggested...

=SUMPRODUCT(('All Data sheet '!D$13:IV$13>=Print!$E$3)*('All Data sheet '!D$13:IV$13<=Print!$E$4)*('All Data sheet '!D21:IV21='All Data sheet '!$D$3*('All Data sheet '!$D$12:$IV$12=$L$1)*('All Data sheet '!D21:IV21<>""))/SUMPRODUCT(('All Data sheet '!D$13:IV$13>=Print!$E$3)*('All Data sheet '!D$13:IV$13<=Print!$E$4)*('All Data sheet '!$D$12:$IV$12=$L$1)*('All Data sheet '!D21:IV21<>"")))

Still comes up with the same results which is > 100%

the formula broken down is as follows:
('All Data sheet '!D$13:IV$13>=Print!$E$3) - greater than a specific date
('All Data sheet '!D$13:IV$13<=Print!$E$4) - Less than a specific date
('All Data sheet '!D21:IV21='All Data sheet '!$D$3 - equal to a number
('All Data sheet '!$D$12:$IV$12=$L$1) - equal to a name
('All Data sheet '!D21:IV21<>"") - greater than a blank