| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=sum
how do you "=sum(A1:A5+A10:A20)" of serveral rows or columns, skip serveral
rows or columns and contuine with the formula |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=sum
Hi
=SUM(A1:A5,A10:A20) Mike "gma" wrote: how do you "=sum(A1:A5+A10:A20)" of serveral rows or columns, skip serveral rows or columns and contuine with the formula |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=sum
=SUM(A1:A5,A10:A20,A25:A30)
If this post helps click Yes --------------- Jacob Skaria "gma" wrote: how do you "=sum(A1:A5+A10:A20)" of serveral rows or columns, skip serveral rows or columns and contuine with the formula |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=sum
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 wrote: how do you "=sum(A1:A5+A10:A20)" of serveral rows or columns, skip serveral rows or columns and contuine with the formula -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=sum
thanks
"Mike H" wrote: Hi =SUM(A1:A5,A10:A20) Mike "gma" wrote: how do you "=sum(A1:A5+A10:A20)" of serveral rows or columns, skip serveral rows or columns and contuine with the formula |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=sum
thanks
"Jacob Skaria" wrote: =SUM(A1:A5,A10:A20,A25:A30) If this post helps click Yes --------------- Jacob Skaria "gma" wrote: how do you "=sum(A1:A5+A10:A20)" of serveral rows or columns, skip serveral rows or columns and contuine with the formula |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
