Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
cannot get concatenated formula to evaluate...
I've spent a lot of time today trying to get this to work, including
searching and reading posts and checking some referenced knowledge base articles. Still no luck. Here's my problem: =SUBSTITUTE(CONCATENATE("=sum(D4:D",endcell,")"),C HAR(34),"") endcell is a named range - the last cell in column G that is greater than zero returns a row number. This evaluates nicely to: =sum(D4:D238) Trouble is I can't get it to work as a formula. I checked all the referenced cells to make sure they were not formatted as text and used F2 everytime I changed the format. Still nothing. Am I barking up the wrong tree or just missing something obvious? I would be grateful for any guidance. Andrew J. Fox P.S. I wasn't sure whether to post this in the excel.misc or the plain excel group. I chose this one because it seemed to have more traffic - hope I was right. ajf |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What is evaluate formula? | Excel Worksheet Functions | |||
Formula Will Not Evaluate | Excel Worksheet Functions | |||
Evaluate formula using VBA | Excel Discussion (Misc queries) | |||
specify range name in formula with concatenated string | Excel Worksheet Functions | |||
concatenated text to formula | Excel Discussion (Misc queries) |