Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Building a formula from another cell
I have a long irregular list of cells that repeat every 6 lines.
Like this: Title blank line 1st shift sales 2nd shift sales 3rd shift sales blank line repeat I can build up a formula like this: =concatenate("=Sum(B",C14,":B",C15,")") where C14="3" and C15="5" for a complete formula of =Sum(B3:B5) to calculate the days sales now,. how can I get it from a text form to an executable form? (Incidentally, when I use the concatenate operation shown above, Excel rips off the last closing parend for some reason.) Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Building a formula from another cell
Not sure how you would convert the text representation of a formula.
You can enter the following formula in C6 and fill down. Assumes Title is in B1 will data repeating underneath it... =IF(AND(LEN(B6)=0,ISNUMBER(OFFSET(B6,-1,0))),SUM(B3:B5),"") -- Jim Cone Portland, Oregon USA Review of Special Sort add-in: http://www.contextures.com/excel-sort-addin.html .. .. .. "zp18" wrote in message I have a long irregular list of cells that repeat every 6 lines. Like this: Title blank line 1st shift sales 2nd shift sales 3rd shift sales blank line repeat I can build up a formula like this: =concatenate("=Sum(B",C14,":B",C15,")") where C14="3" and C15="5" for a complete formula of =Sum(B3:B5) to calculate the days sales now,. how can I get it from a text form to an executable form? (Incidentally, when I use the concatenate operation shown above, Excel rips off the last closing parend for some reason.) Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Building a formula from another cell
Correction:
"Assumes Title is in B1 will data repeating underneath it..." Should read... "Assumes Title is in B1 with data repeating underneath it..." |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Building a formula from another cell
Do you mean something like this:
=SUM(INDIRECT("B"&C14):INDIRECT("B"&C15)) ? On Aug 3, 4:53*am, zp18 wrote: I have a long irregular list of cells that repeat every 6 lines. Like this: Title blank line 1st shift sales 2nd shift sales 3rd shift sales blank line repeat I can build up a formula like this: =concatenate("=Sum(B",C14,":B",C15,")") where C14="3" and C15="5" for a complete formula of =Sum(B3:B5) to calculate the days sales now,. how can I get it from a text form to an executable form? (Incidentally, when I use the concatenate operation shown above, Excel rips off the last closing parend for some reason.) Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with building a formula based on cell values | Excel Programming | |||
building a formula | Excel Programming | |||
Building Excel Formula that Returns the Column of Last Cell with Data | Excel Programming | |||
VBA formula building | Excel Programming | |||
When building formula in excel, it would be very useful to have t. | Excel Programming |