LinkBack URL
About LinkBacks
=SUMPRODUCT((master!$A$2:$A$200=analyze!$B$2)*(master!$B$2:$B$200=analyze!A3)*(master!$D$2:$F$200<>""))
but, as previously stated... no whole column references, unless you DO have 1,000,000 rows of data
=SUMPRODUCT((master!$A$2:$A$200=analyze!$B$2)*(master!$B$2:$B$200=analyze!A3)*(master!$D$2:$F$200<>""))
but, as previously stated... no whole column references, unless you DO have 1,000,000 rows of data
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks