Forum Discussion
adding downward columns across an excel sheet
i am trying to add columns across an excel spreadsheet. So.. say from row 254 to 321. is there a quick way of doing this for columns say C to P
Yes I realise I can add doing what you suggested, but I just want to go along a row and add up a section of each column, not the complete column and I wondered if there was a quick way to do it.
Your example :-Eg: =SUM(A1:D1) would add the numbers in the first row of columns A through
=SUM(A1:A34) would add the rows in column a from row 1 to row 34.
I want to =SUM columns A to M, but only rows (say) 10-30 within those columns.
Is this possible.
Thanks
As advised, If you played around with the function SUM(), you can actually sum rows and columns together. i.e, =SUM(A10:M30)