Sep 22 2021 03:35 AM
Hi Folks. Apologies from the outset: I'm not great with Excel.
I'm using an simple Excel spreadsheet that I set up a long time ago. I have a "Totals" column where the final cell contains a formula that is copied from the cell above it which in turn is copied from the cell above that one, etc., etc. So far the copy has worked over 1500 times. The actual formula reads: =SUM(S1975+P1976-Q1976) and so the resulting value changes according to what figures are entered in the P and Q cells. However all I get is a ~VALUE! message. I've tried entering the formula myself rather than copying it but I still get the same error message. I can see no mistakes in the figures I've put it into P and Q cells and no error in the formula I'm putting in manually. Help, please!
Sep 22 2021 03:51 AM
SolutionSep 22 2021 04:17 AM
Sep 22 2021 04:18 AM
Sep 22 2021 03:51 AM
Solution