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.
|