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
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