Hi
please could anyone tell me how to sum only right part of the cell (which always will be one or two digits number ) along one row but many columns
B4 C4 D4
Fri 02/01/2015 , 5 Thu 01/01/2015 , 12 Sat 05/01/2015 , 3
thanks
Jo
Hi
please could anyone tell me how to sum only right part of the cell (which always will be one or two digits number ) along one row but many columns
B4 C4 D4
Fri 02/01/2015 , 5 Thu 01/01/2015 , 12 Sat 05/01/2015 , 3
thanks
Jo
based on the example try this.
Confirmed with ctrl+shift+enter (not just enter)
Formula:Please Login or Register to view this content.
Is there ALWAYS a space between the comma and the number?
Try
=SUMPRODUCT(RIGHT(0&B4:D4,2)+0)
Note: if you have entered only date (or any other number that you don't want to SUM) you'll get a wrong result.
Rather put some text at the end to avoid that.
Thanks so much, both options work.
I tried SUMPRODUCT but obviously did it wrong.
I will be a frequent guest of this forum, I got problems all the time
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks