I'm getting things to work little by little. DonkeyOte, your plan worked.
I'm curious now, what if I want to substitute the numbers to letters.
Can I get A,B,C to show up in B1 as A+B+C.
Ultimately, I want the variables to refer to its value defined on another sheet and then C1 will actually express the numerical total.
Thank you!
If you're saying you have three named constants - say _A, _B, _C then
A1: _A,_B,_C
should still generate the appropriate output in B1 (ie the sum of those three constants), yes.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
If you just want to display A,B,C as A+B+C, you could use part of what Martin postedWould that work for you?
=SUBSTITUTE(A1,",","+")
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Danexcel 
Register To Reply
Bookmarks