Home |
Search |
Today's Posts |
#1
|
|||
|
|||
sum of many cells
hello, I want to write a script to make a sum of all the not empty cells within a column. Is there a trick so that Excel doesn't calculate all cells, only the not empty cells, so the calculation will be much faster? thx in advance, Kizzie -- kizzie ------------------------------------------------------------------------ kizzie's Profile: http://www.excelforum.com/member.php...o&userid=26092 View this thread: http://www.excelforum.com/showthread...hreadid=394873 |
#2
|
|||
|
|||
I don't think you'll notice the difference.
In fact, if you make the formula complex enough to ignore empty cells, it might even take longer to recalculate--just because it's doing more stuff. (I wouldn't bother.) kizzie wrote: hello, I want to write a script to make a sum of all the not empty cells within a column. Is there a trick so that Excel doesn't calculate all cells, only the not empty cells, so the calculation will be much faster? thx in advance, Kizzie -- kizzie ------------------------------------------------------------------------ kizzie's Profile: http://www.excelforum.com/member.php...o&userid=26092 View this thread: http://www.excelforum.com/showthread...hreadid=394873 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do you "select locked cells" w/o "select unlocked cells"? | Excel Discussion (Misc queries) | |||
Deselect Cells while using ctrl | Excel Discussion (Misc queries) | |||
Counting only active cells | Excel Discussion (Misc queries) | |||
Help adding text values | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |