View Single Post
Old 01-23-2020, 09:26 AM
ibgreat1 ibgreat1 is offline Windows XP Office 2003
Join Date: Aug 2009
Posts: 7
ibgreat1 is on a distinguished road
Default 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:

I can sum with something like this, but it won't trim correctly:

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.
Reply With Quote