G
gma
how do you "=sum(A1:A5+A10:A20)" of serveral rows or columns, skip serveral
rows or columns and contuine with the formula
rows or columns and contuine with the formula
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Mike H
Hi
=SUM(A1:A5,A10:A20)
Mike
=SUM(A1:A5,A10:A20)
Mike
J
Jacob Skaria
=SUM(A1:A5,A10:A20,A25:A30)
If this post helps click Yes
If this post helps click Yes
D
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)
=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)
G
gma
G
gma
thanks
Jacob Skaria said:=SUM(A1:A5,A10:A20,A25:A30)
If this post helps click Yes