I am trying to do a project budget and I'm adding 2 cells that are not next
to each other in the spreadsheet. I do the automatic sum calculation with
this formula- Sum(R122,R183). A non value appears.
I did the long version of picking it through the Insert Function box. The
cells are chosen, and the formula result displays the correct total of the
two boxes. Click OK and the non value appears.