LinkBack URL
About LinkBacks
If as it seems the data is stored in the same file as the calculation itself then there is no need for SUMPRODUCT at all
which would be more efficient
=SUMIF(RawMarketers,$C$3,RawDateGap)/COUNTIF(RawMarketers,$C$3)
or if using XL2007+ use AVERAGEIF
If as it seems the data is stored in the same file as the calculation itself then there is no need for SUMPRODUCT at all
which would be more efficient=SUMIF(RawMarketers,$C$3,RawDateGap)/COUNTIF(RawMarketers,$C$3)
or if using XL2007+ use AVERAGEIF
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