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

E

Elwood

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

Max

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

Frank Kabel

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
 
C

count

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
 
Top