Sumproduct formula

[xxsalahxx]

hello im using a sumproduct formula, however its not calculating properly the sheet that the data is coming from has merged cells but need to stay that way im wondering if its because there is blanks cells in column R.

The formula im using is: =SUMPRODUCT(--('10. VERIFIED (L) '!$R$5:$R$10000>=61),--('10. VERIFIED (L) '!$R$5:$R$10000<=90),--('10. VERIFIED (L) '!$B$5:$B$10000='VERIFIED DAYS'!B11))

Does anyone have any ideas where im going wrong still quite a novice when it comes to sumproducts, ANy help is appreciated. Thank you

 

[CA_Punit]

I dont think there is anything wrong in the formula.
Can you post a sample file using xl2bb

 

[gaz_chops]

Get rid of your merged cells