#1
|
|||
|
|||
Sum Denominators - Use Array?
Hello All,
I'm trying to sum denominators from a range with a formula. I know I could write this into a script, but trying not to do that for other users in the future. All cells won't contain a value. Values in cells look something like = 5/7 I can trim for varying lengths with: =RIGHT(FORMULATEXT(A1), LEN(FORMULATEXT(A1))-FIND("/", FORMULATEXT(A1))) I can sum with something like this, but it won't trim correctly: =SUMPRODUCT(--(RIGHT(FORMULATEXT(A1:BZ1),1))) I thought about using a helper row and/or creating an array of the trimmed values, but I think I run into the same issue of applying it to the range/array. Maybe pull the text values into the array and trim the values within the array? Thinking out out, but I'll go back to try a few more things. I couldn't find anything in a search, but feel like I should be able to apply the 1st formula to a range. |
#2
|
|||
|
|||
Maybe this can be of some help.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Concatenating in an Array formula | Phil H | Excel | 6 | 02-25-2019 08:36 AM |
Array Formula | Macacidic | Excel | 2 | 09-12-2017 08:19 AM |
looking to persist and array or something | vthomeschoolmom | Word VBA | 1 | 09-16-2015 02:12 PM |
Insertbefore an array? help :( | n00bie-n00b | Word VBA | 21 | 08-21-2014 08:03 PM |
Convert String Array to Integer Array from a User Input? | tinfanide | Excel Programming | 4 | 12-26-2012 08:56 PM |