LinkBack URL
About LinkBacks
newx 
Copy this formula into Sheet2!BS2 and copy down:
=SUMPRODUCT((Sheet1!A2:P2+1=Sheet1!B2:Q2)*(Sheet1!A2:P2<>""))
Copy this formula into Sheet2!BS2 and copy down:
=SUMPRODUCT((Sheet1!A2:P2+1=Sheet1!B2:Q2)*(Sheet1!A2:P2<>""))
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks