Hello again all smart folks,
And i have to represent operation into cells but result have to be a real number,
all this i tried to explain in mz attached sample.
Thnk u in advance for your effort.
Hello again all smart folks,
And i have to represent operation into cells but result have to be a real number,
all this i tried to explain in mz attached sample.
Thnk u in advance for your effort.
In E2:
=LEFT(A2,FIND("x",A2)-1)*RIGHT(A2,FIND("x",A2))+LEFT(B2,FIND("x",B2)-1)*RIGHT(B2,FIND("x",B2))+LEFT(C2,FIND("x",C2)-1)*RIGHT(C2,FIND("x",C2))+LEFT(D2,FIND("x",D2)-1)*RIGHT(D2,FIND("x",D2))
Or you can use the below array:
=SUM(LEFT(A2:D2,FIND("x",A2:D2)-1)*RIGHT(A2:D2,FIND("x",A2:D2)))
This needs you confirming the formula by pressing CTRL+SHIFT+ENTER
If you are unfamiliar with arrays then I recommend using the first method to avoid any issues.
Say thanks, click *
In cell E2...
=SUMPRODUCT(LEFT(A2:D2,FIND("x",A2:D2)-1)*RIGHT(A2:D2,LEN(A2:D2)-FIND("x",A2:D2)))
Ah good old sumproduct, I always overlook this function for some reason...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks