• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

sum

C

chevalblanc

New Member
There are 12 columns (Jan to Dec) with figures and I need to sum each column figures. How can I do it in one go without doing the sum for individual column?
 
Hi, chevalblanc!


Assuming your data in row 1, columns A thru L, type this in the desired cell:

=SUM(A1:L1)

If data is in another row or adjacent columns, adjust the range properly.


Regards!
 
Hi,


If you are looking for a single formula to sum the all the columns and rows then you can use SUM() with First Column/ First Row: Last Column/Last Row.


example SUM(A1:L200)
 
Hi, chevalblanc!


After reading kchiba post, which led me to read again your first one... I think I misread at a first glance. His suggestion appears to be more accurate than mine for what you asked. Just add that for summing all 12 column data altogether you may type:

=SUM(A:L)


Regards!
 
You need to be very careful with a formula like: =SUM(A:L)


If the column headers are true Dates and not text, they are numbers even though they may be displayed as text, and as numbers they will be included in the summation.

ie: Today (11 April 2012) is day 41,010, so adding 12 months will add approximately 500,000 to your results.
 
You must log in or register to reply here.
Back
Top