Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to SUM the *entire* column?
I already know how to sum a *range* of cells.
Click, drag, release, and then click on the Sigma icon. That sums up a range of cells. I want to sum up the whole column. The *entire* column. I don't want to have some silly formula like "sum from one to billion". Is there a formula for summing the entire column? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to SUM the *entire* column?
Try something like:
=sum(a:a) to sum the entire column a. Good luck. Ken Norfolk, Va On Feb 9, 5:54 pm, "Arctic Wolf" -NoSpam wrote: I already know how to sum a *range* of cells. Click, drag, release, and then click on the Sigma icon. That sums up a range of cells. I want to sum up the whole column. The *entire* column. I don't want to have some silly formula like "sum from one to billion". Is there a formula for summing the entire column? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to SUM the *entire* column?
have you tried
=sum(f:f) I wouldn't put it in the 1st row of the column desired. -- Don Guillett SalesAid Software "Arctic Wolf" -NoSpam wrote in message hlink.net... I already know how to sum a *range* of cells. Click, drag, release, and then click on the Sigma icon. That sums up a range of cells. I want to sum up the whole column. The *entire* column. I don't want to have some silly formula like "sum from one to billion". Is there a formula for summing the entire column? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup function/sum function | Excel Discussion (Misc queries) | |||
How do I combine spreadsheets and documents in one file? | Excel Discussion (Misc queries) | |||
macro | Excel Discussion (Misc queries) | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions |