=sum

[gma]

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]

Hi

=SUM(A1:A5,A10:A20)

Mike

 

[Jacob Skaria]

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

If this post helps click Yes

 

[Dave Peterson]

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]

thanks

Hi

=SUM(A1:A5,A10:A20)

Mike

 

[gma]

thanks

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

If this post helps click Yes