Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-23-2020, 09:26 AM
ibgreat1 ibgreat1 is offline Sum Denominators - Use Array? Windows XP Sum Denominators - Use Array? Office 2003
Novice
Sum Denominators - Use Array?
 
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:
=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.
Reply With Quote
  #2  
Old 01-23-2020, 11:12 PM
xor xor is offline Sum Denominators - Use Array? Windows 10 Sum Denominators - Use Array? Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,037
xor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of light
Default

Maybe this can be of some help.
Attached Files
File Type: xlsx Sum_Denominators.xlsx (11.4 KB, 3 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sum Denominators - Use Array? 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
Sum Denominators - Use Array? 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
Sum Denominators - Use Array? Convert String Array to Integer Array from a User Input? tinfanide Excel Programming 4 12-26-2012 08:56 PM


All times are GMT -7. The time now is 12:12 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft