Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Variable Length Columns
I am trying to set up a template with formulas into which I can simply drop
data into and Excel will then run the calculations. However, the data I will be entering will have many different lengths. How can I make formulas and equations to handle the variable lengths of my data? For example, how do I sum the entries in a column if I do not know how many entries the column will have? Or, how do I sum a column and omit the #DIV/0 entries that will appear in that column? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Variable Length Columns
Hi,
I'd fix my formula to eliminate the errors but you can sum the full column and ignore the errors =SUMIF(A:A,"<#DIV/0!") -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Gucktly" wrote: I am trying to set up a template with formulas into which I can simply drop data into and Excel will then run the calculations. However, the data I will be entering will have many different lengths. How can I make formulas and equations to handle the variable lengths of my data? For example, how do I sum the entries in a column if I do not know how many entries the column will have? Or, how do I sum a column and omit the #DIV/0 entries that will appear in that column? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Variable Length Columns
- set up your formula in column A referencing B thru IV
- use the ol' if(a1=0,0,b1/a1) workaround. -- Hope this helps. If it does, please click the Yes button. Thanks in advance for your feedback. Gary Brown "Gucktly" wrote: I am trying to set up a template with formulas into which I can simply drop data into and Excel will then run the calculations. However, the data I will be entering will have many different lengths. How can I make formulas and equations to handle the variable lengths of my data? For example, how do I sum the entries in a column if I do not know how many entries the column will have? Or, how do I sum a column and omit the #DIV/0 entries that will appear in that column? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Right function variable length | Excel Worksheet Functions | |||
Graphing Variable-length columns | Charts and Charting in Excel | |||
Referencing a Value in variable length columns. | Excel Worksheet Functions | |||
Sum a Column of Variable length | Excel Discussion (Misc queries) | |||
Sum a column of variable length? | Excel Discussion (Misc queries) |