Forum Discussion
Solved
Formulas
I have been using Excel for many years but just in the last couple of days, something has happened to the Formula function in my spreadsheets. I set the formula to add boxes A1 through to say A20 in ...
Hi,
You probably have the calculation option in the manual state!
Please make sure the calculation option is set to Automatic as follows:
Hope that helps
Hi
One more option to add
Assuming that you have values From A1 to E20
Select all the source values from A To E but when you drag, drag down 2 more rows (A1:E22) so you are actually including the destination row
Then
One Click on the AutoSum tool (either Home Tab or Formula Tab) >> We are done!!
NB: alternative to clicking the AutoSum, and with the same selection:
Use the Shortcut: ALT and Double Click on the EQUAL sign (ALT, =,= Fast and simultaneously)
Hope that helps
Nabil Mourad