MidnightTim
New Member
- Joined
- Oct 18, 2020
- Messages
- 4
- Office Version
- 365
- Platform
- Windows
Hello Everyone,
I don't fancy myself to be an excel Guru but I am usually pretty crafty when. I'm working on a spreadsheet and I'm trying to add up all the denominators across multiple cells in a row.
The formula I'm using is
This works if the denominator is 2 digits but not if it's 1 digit. If the cell is 10/10 or or 9/10 or 15/20 it counts with no problem. If the cell is 1/9 8/9 etc it doesn't count. Making any changes to the -2 in the code just breaks the formula.
I do not seem to be able to attach my spreadsheet to this post.
I don't fancy myself to be an excel Guru but I am usually pretty crafty when. I'm working on a spreadsheet and I'm trying to add up all the denominators across multiple cells in a row.
The formula I'm using is
Excel Formula:
=SUMPRODUCT(--(RIGHT(0&J2:BY2,FIND("/",0&J2:BY2)-2)))
This works if the denominator is 2 digits but not if it's 1 digit. If the cell is 10/10 or or 9/10 or 15/20 it counts with no problem. If the cell is 1/9 8/9 etc it doesn't count. Making any changes to the -2 in the code just breaks the formula.
I do not seem to be able to attach my spreadsheet to this post.