LinkBack URL
About LinkBacks
Traditional solution pre XL2007 would be SUMPRODUCT, eg:
=SUMPRODUCT(--($A$1:$A$100="ABC"),--($B$1:$B$100="PQR"),--($C$1:$C$100="IJK"),--($D$1:$D$100>2005))
Traditional solution pre XL2007 would be SUMPRODUCT, eg:
=SUMPRODUCT(--($A$1:$A$100="ABC"),--($B$1:$B$100="PQR"),--($C$1:$C$100="IJK"),--($D$1:$D$100>2005))
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks