My code works fine in my test sheet, but when i enter it in my active sheet i get a value error...any suggestions?
I really don't know what i'm doing wrong, literally pulling my hair out.
Any help as to why im getting this error will be greatly appreciated.

the below code works perfectly in my test sheet and returns all values correctly, somehow when I enter it in the sheet that matters, boom value error.

```
=IF(J5="YES",SUM((E10:I610>11538)*(E10:I610<=34760)*(A10:A610="No")*ROUND(E10:I610*0.056,0))+SUM((E10:I610>34760)*ROUND(34760*0.056,0)),0) 

```