Mar 20 2022 08:54 AM
I am brand new to Excel. What is the formula to add three rows of columns
thanks
Mar 20 2022 09:19 AM
Could you explain in more detail what exactly you want to add?
Mar 20 2022 09:48 AM
Hi Hans
I am brand new to Excel. I have twelve columns. I want to add the twelve rows across. I also want to add the twelve columns across .
Thanks
Gary
Mar 20 2022 10:03 AM
Let's say you have data in B2:M13.
In N2, enter the formula =SUM(B2:M2)
Fill or copy down from N2 to N13.
In B14, enter the formula =SUM(B2:B13)
Fill or copy to the right to N14.
See the attached sample workbook.
Mar 20 2022 10:14 AM