Problem:
A1
Book1 2500
Book2 500
Book3 1000
B1 - I need the total SUM of the number values in A1 which is 4000
Can someone get the formula for B1 please?
Problem:
A1
Book1 2500
Book2 500
Book3 1000
B1 - I need the total SUM of the number values in A1 which is 4000
Can someone get the formula for B1 please?
=SUM(IFERROR(TRIM(MID(SUBSTITUTE(SUBSTITUTE(A1,CHAR(10)," ")," ",REPT(" ",LEN(A1))),(ROW(1:20)-1)*LEN(A1)+1,LEN(A1)))+0,0))
TRY THIS ARRAY FORMULA (Shift+Ctrl+Enter)
IT WILL WORK FOR 20 Items
if it is more than that edit ROW(1:20) as per your requirement
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks