Hi,

I'm using the following formula =SUM((T2:T245 ="Retail EH Approved")*(L2:L245<=5000)*U2:U245) to basically look up the value of all Retail EH Approved within the sheet but the result coming up is only for the line the formula is on yet if I click the FX button it shows me the correct value!

Help please!!!