LinkBack URL
About LinkBacks
keis386 
you could use sumproduct if your workig with numbers
try this
(and switch your 0s to view on in excel options)
=SUMPRODUCT(($K$1:$V$1=$A2)*($J$3:$J$9=B$1),$K$3:$V$9)
you could use sumproduct if your workig with numbers
try this
(and switch your 0s to view on in excel options)=SUMPRODUCT(($K$1:$V$1=$A2)*($J$3:$J$9=B$1),$K$3:$V$9)
The Importance of INDEX - A GUIDE TO INDEX'S OTHER USES
<--- If a post helps hit the star
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks