LinkBack URL
About LinkBacks
You might also try
=SUMPRODUCT((TEXT(Data!$A$2:$A$10000,"mmyy")="0114")*(Data!$I$2:$I$10000="Bulk")*(Data!$K$2:$K$10000=$A3)*(Data!$P$2:$P$10000=$B3)*(Data!$Q$2:$Q$10000=$C3))
You might also try
=SUMPRODUCT((TEXT(Data!$A$2:$A$10000,"mmyy")="0114")*(Data!$I$2:$I$10000="Bulk")*(Data!$K$2:$K$10000=$A3)*(Data!$P$2:$P$10000=$B3)*(Data!$Q$2:$Q$10000=$C3))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks