LinkBack URL
About LinkBacks
Respected Sir...
In the excel, there are Seven Cells which contains marks as below:
38
39
42
27+08
47
25+10
29+06
As per above I want the result as "271" in the eighth cell..
Kindly help.. Thanks in advance...
Sum of seven cell if cell contains "+" (Plus) mark
Respected Sir...
In the excel, there are Seven Cells which contains marks as below:
38
39
42
27+08
47
25+10
29+06
As per above I want the result as "271" in the eighth cell..
Kindly help.. Thanks in advance...
Maybe:
How to install your new code
Please Login or Register to view this content.
Copy the Excel VBA code
Select the workbook in which you want to store the Excel VBA code
Press Alt+F11 to open the Visual Basic Editor
Choose Insert > Module
Edit > Paste the macro into the module that appeared
Close the VBEditor
Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)
Then:
=SumTotal(A1:A7)
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Will it always be 2 digits? And will it always be a plus sign?
Also, are you fine with VBA?
Cheers!
Deep Dave
Try this ...
=SUMPRODUCT(--MID(SUBSTITUTE(A1:A7&"+0","+",REPT(" ",100)),{1,101},100))
@Phuocam - That is a beautiful formula..
Last edited by NeedForExcel; 03-14-2018 at 05:15 AM.
Phuocam... That's really great. It might need a tweak, as it breaks if there is an empty cell in the range.
YESSSSSSSSS... This formula working Great... Thank you. Everyone...Originally Posted by Phuocam
Out of interest.... if there are blank cells in the range, this is the minor adjustment required to Phuocam's formula to keep it working...
=SUMPRODUCT(--MID(SUBSTITUTE(0&A1:A7&"+0","+",REPT(" ",100)),{1,101},100))
Even this is great..
I did think of a lousy solution -
=SUMPRODUCT(IFERROR(--MID(SUBSTITUTE(C33:C39&"+0","+",REPT(" ",100)),{1,101},100),0))
Iferror turned it into an Array formula.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks