Thank you!
If that A1 cell data suddenly becomes just 1,4,6 will the formula you mentioned handle it?
Is there not a general formla that sums.
By the way, what is the SUM formula if I have 1,4,6 ?
Thanks
Dan
Thank you!
If that A1 cell data suddenly becomes just 1,4,6 will the formula you mentioned handle it?
Is there not a general formla that sums.
By the way, what is the SUM formula if I have 1,4,6 ?
Thanks
Dan
The point being made is whether or not the "Numbers" are always single digits.
One approach would be to use a Name... insert a new name as follows:
Then![]()
Name: EVAL RefersTo =Evaluate("SUM("&INDIRECT("RC[-1]",FALSE)&")")
EDIT: the above is just another variant on martin's prior post![]()
B1: =EVAL where A1 holds delimited string
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks