How can I sum non-consecutive numbers in a column?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Any ideas would be greatly appreciated. its driving me crazy summing large
numbers of non-consecutive cells.
 
Maybe try this ..

Suppose you want to sum in say A2,
the numbers in

A4:A5
A7:A14
A19:A24
A26
A28

Enter in A2: =SUM(

Hold down the CTRL key

Now just click to select

A4:A5
A7:A14
A19:A24
A26
A28

Type a closing parens, press Enter

You'll get in A2: =SUM(A4:A5,A7:A14,A19:A24,A26,A28)
 
Hi
is there a logic which cell should be summed. e.g. every second cell, etc.
You may provide some more details about your exact spreadsheet layout
 
Elwood,
If there's no logic there yet - as Frank suggests - you might try to
introduce one by inserting, say, extra column with markers and employ
function SUMIF, based on these markers. Post a question if unclear.
Paul
 
You must log in or register to reply here.

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

Any (6) consecutive entries 4
In Excel, print non-consecutive columns. 1
Cell calculation 3
Excel coolumn headings changed from A, B, C, etc. to 1, 2, 3 1
selecting non consectutive cells/rows/columns in excel 2007 3
Excel Count of Consecutive Data 0
counting blanks in a non-consecutive range 3
Search for a sum! 4

Back
Top