=SUMPRODUCT((Sheet1!F$1=Sheet1!$B$2:$M$2)*(L2=Sheet1!$A$3:$A$31)*(Sheet1!B3:M3))
put this in h2 sheet 2...
=SUMPRODUCT((Sheet1!F$1=Sheet1!$B$2:$M$2)*(L2=Sheet1!$A$3:$A$31)*(Sheet1!B3:M3))
put this in h2 sheet 2...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks