I am reading values from several worksheets that are compiling on a front
worksheet. However, when I try to sum those values my formula is not
recognizing the later cell values.
=IF(AB20,AB2,P2+S2+V2+Y2)
Anyone experience this and how did you resolve it?
By the way, I'm running Excel 07.
Thanks