Formula

New Contributor

I am brand new to Excel. What is the formula to add three rows of columns

thanks

4 Replies

@GaryWapinski 

Could you explain in more detail what exactly you want to add?

@Hans Vogelaar 

 

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

@GaryWapinski 

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.

Thanks Hans
That is exactly what I am looking to do. I will work on it later today.

Gary