Try this regular formula
Adjuts ranges accordingly![]()
=SUMPRODUCT((A1:C1)*TRIM(SUBSTITUTE(A2:C2,"Hotdogs","")))
Try this regular formula
Adjuts ranges accordingly![]()
=SUMPRODUCT((A1:C1)*TRIM(SUBSTITUTE(A2:C2,"Hotdogs","")))
Life's a spreadsheet, Excel!
Say thanks, Click *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks