British
Registered User

Hi. I need some help with a formula. I'm trying to sum figures based on 3 criteria. I'm using a combination of sum and if array formulas - but the answer is coming out to zero.

=SUM(IF('Budget Detail'!$C$7:$C$3000='RBL '!$H52,IF('Budget Detail'!$B$7:$B$3000='RBL '!N2,IF('Budget Detail'!$BA$7:$BA$3000='RBL '!$O3,'Budget Detail'!$S$7:$S$3000,0),0)))

I'm using the above formula - with ctrl+shift+enter - to get the brackets around it....

Can anyone let me know what is wrong with the above formula?