LinkBack URL
About LinkBacks
Use cells to hold the criteria.
A1 = 1
B1 = Free
=SUMPRODUCT(--(LEFT(AC2:AC6909)=A1&""),--(Range=B1))
Use cells to hold the criteria.
A1 = 1
B1 = Free
=SUMPRODUCT(--(LEFT(AC2:AC6909)=A1&""),--(Range=B1))
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)
Posting Permissions
Register To Reply
Bookmarks