Refer to the attached spreadsheet on the Summary Day Count tab in cell M13. I would like to add to the SUMPRODUCT formula that I have and say if the appropriate cell in the range $AI$3:$AI$20000 has a blank value then not to include it in the Total # count. Can anyone help with this asap? Thanks a lot!
Perhaps
you should (IMO) be wary of over using SUMPRODUCT...
=SUMPRODUCT(--('Analyst Changes Database'!$AH$3:$AH$240=$B13),--('Analyst Changes Database'!$AG$3:$AG$240="Decreased"),--('Analyst Changes Database'!$AI$3:$AI$240<>""))
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Thanks this is perfect!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
rhudgins 
Register To Reply
Bookmarks