Sumproduct with different number formats
 

I am using the following formula to sum rows based on the name in cell
A and the month in row 4. It works until I change my row limit from 54
to 55. In row 55 my number format changes from currency to percentage.
I will never need to add the rows with percentages, but will need the
formula to be from B6:M200. Any suggestions? (Thanks in advance.)


=SUMPRODUCT(('AHB - Actual'!$B$6:$M$54)*('AHB -
Actual'!$A$6:$A$54=$A4)*('AHB - Actual'!$B$4:$M$4<=B$2))