=sum

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
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sum character 6
Excel 2000 formula to dynamically sum adjacent rows and columns whererows inserted/deleted 3
Copy addition formula of non-consecutive horizontal cells 2
multipule calculations in a single column 2
formula for arriving net difference 0
Copy the content of a cell with Formula 1
CAN A VALUE BE RETURNED WHEN TEXT IS ENTERED IN A DIFFERANT CELL? 1
Multiple IF Statement in Word 5

Top