Alternatively
Sheet2!C2:
=SUMPRODUCT((Sheet1!$C$2:$N$1001=$A2)*Sheet1!$B$2:$B$1001)
confirmed with Enter
copied down
Alternatively
Sheet2!C2:
=SUMPRODUCT((Sheet1!$C$2:$N$1001=$A2)*Sheet1!$B$2:$B$1001)
confirmed with Enter
copied down
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks