Try this in AG3:
Confirmed with Ctrl-Shift-Enter![]()
=SUMPRODUCT(IF(ISNUMBER(SEARCH("L",B3:AE3)),--SUBSTITUTE("L"&UPPER(B3:AE3),"L",0),0))-AF3
Try this in AG3:
Confirmed with Ctrl-Shift-Enter![]()
=SUMPRODUCT(IF(ISNUMBER(SEARCH("L",B3:AE3)),--SUBSTITUTE("L"&UPPER(B3:AE3),"L",0),0))-AF3
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks