LinkBack URL
About LinkBacks
This formula will inore the text and sum only number on left side of pipe symbol
Don't forget to press CSE (Ctril + Shift + Enter)
{=SUM(IF(ISNUMBER(--LEFT(A1:A4,FIND("|",A1:A4)-1)),(--LEFT(A1:A4,FIND("|",A1:A4)-1)),0))}
This formula will inore the text and sum only number on left side of pipe symbol
Don't forget to press CSE (Ctril + Shift + Enter)
{=SUM(IF(ISNUMBER(--LEFT(A1:A4,FIND("|",A1:A4)-1)),(--LEFT(A1:A4,FIND("|",A1:A4)-1)),0))}
If this post helps, Please don't 4get to click the star icon located at the bottom left of my Post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks