Maybe this...
=SUMPRODUCT(ISNUMBER(SEARCH(G15,$B$4:$B$15))*($C$3:$E$3=G16)*(C4:E15>0))
Maybe this...
=SUMPRODUCT(ISNUMBER(SEARCH(G15,$B$4:$B$15))*($C$3:$E$3=G16)*(C4:E15>0))
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks