View Single Post
 
Old 01-13-2017, 10:26 AM
Cyberseeker Cyberseeker is offline Windows 10 Office 2010 32bit
Advanced Beginner
 
Join Date: Jun 2016
Posts: 44
Cyberseeker is on a distinguished road
Default

That worked well Jeffrey, but I omitted mentioning in the opening post that I wanted to add another cell at the same time. So, I inserted it into your code as follows:


Code:
=(SUM((TRIM(MID(SUBSTITUTE(B75,"+",REPT(" ",255)),1+(ROW(A1:A200)-1)*255,255)) & "0")/10)+SUM((TRIM(MID(SUBSTITUTE(B76,"+",REPT(" ",255)),1+(ROW(A1:A200)-1)*255,255)) & "0")/10))/29.5306
I suspect that my code is unnecessarily longwinded because there are two numbers in the first cell but the second cell only contains one figure. Can you condense it for me?

Incidentally, my project relates to a soli-lunar calendar.
Reply With Quote