16.0k views
4 votes
Spreadsheet formula for total 91?​

User Perraco
by
7.3k points

1 Answer

3 votes

Answer:

Go to any blank cell. Enter the number 91.

Select the cell that contains 91. Press Ctrl+C to copy.

Select your range the contains numbers.

Press Ctrl+Alt+V to open the Paste Special dialog.

In the top of the Paste Special dialog, choose Values. In the Operation section, choose Add. Click OK.

Step-by-step explanation:

User Manish Basantani
by
7.0k points