ExcelBanter

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - =sum (https://www.excelbanter.com/excel-worksheet-functions/229700-%3Dsum.html)

gma

=sum

how do you "=sum(A1:A5+A10:A20)" of serveral rows or columns, skip serveral
rows or columns and contuine with the formula

Mike H

=sum

Hi

=SUM(A1:A5,A10:A20)

Mike

"gma" wrote:

how do you "=sum(A1:A5+A10:A20)" of serveral rows or columns, skip serveral
rows or columns and contuine with the formula

Jacob Skaria

=sum

=SUM(A1:A5,A10:A20,A25:A30)

If this post helps click Yes
---------------
Jacob Skaria

"gma" wrote:

how do you "=sum(A1:A5+A10:A20)" of serveral rows or columns, skip serveral
rows or columns and contuine with the formula

Dave Peterson

=sum

Some other variations...

=sum(a1:a5)+sum(a10:a20)
or
=sum(a1:a20)-sum(a6:a9)

You may find it easier to add an indicator column:

I used column B with an X in it if it should be summed:
=sumif(b1:b20,"X",a1:a20)

If you used X to indicate that the cell should be skipped:
=SUMIF(B1:B20,"<"&"X",A1:A20)

gma wrote:

how do you "=sum(A1:A5+A10:A20)" of serveral rows or columns, skip serveral
rows or columns and contuine with the formula

--

Dave Peterson

gma

=sum

thanks

"Mike H" wrote:

Hi

=SUM(A1:A5,A10:A20)

Mike

"gma" wrote:

how do you "=sum(A1:A5+A10:A20)" of serveral rows or columns, skip serveral
rows or columns and contuine with the formula

gma

=sum

thanks

"Jacob Skaria" wrote:

=SUM(A1:A5,A10:A20,A25:A30)

If this post helps click Yes
---------------
Jacob Skaria

"gma" wrote:

how do you "=sum(A1:A5+A10:A20)" of serveral rows or columns, skip serveral
rows or columns and contuine with the formula

All times are GMT +1. The time now is 08:36 AM.