Hi Darkyam,
Yup, you are right. There are data below my under the Column J after the P&L.
By doing the multiply paste special, is it the same as changing all my IF to 1*IF in all the P&L under column J? I did try both ways but I still get #NA. I also notice my conditional formatting are gone. Did I do it wrongly?
I have attached my sample here with the suggested solution.
Bookmarks