I have a spread sheet and have a row in which I have added the charges for the month. I want to take the totals for each month and add them up to get an annual total. When I copy the row of sums and put it in a summary section the subsequent line are added together to a preposterous number. How can I simply copy the values and then add them up for my annual totals?
Are you talking of >Edit>Paste Special... -no Formulas, no Formats… ?
It’s available also with right-click Paste special - Number
…and with Shift+Ctrl+V.