Try this ARRAY formula. Confirm with Control+Shift+Enter
=SUM(IF(ISNUMBER(B1:B26),(B1:B26),0)*ISNUMBER(MATCH(A1:A26,E3:E7,0)))
Try this ARRAY formula. Confirm with Control+Shift+Enter
=SUM(IF(ISNUMBER(B1:B26),(B1:B26),0)*ISNUMBER(MATCH(A1:A26,E3:E7,0)))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks