"empty cells" would not generate the #N/A error.
It sounds as though you have underlying error values in either of or indeed both of the ranges referenced ... on which basis: what does the below return ?
=SUM(IF(NOT(ISNA(Sheet1!$D$2:$D$5000))*ISNUMBER(Sheet1!$I$2:$I$5000);(Sheet1!$D$2:$D$5000=$A2)*Sheet1!$I$2:$I$5000)) confirmed with CTRL + SHIFT + ENTER
Last edited by DonkeyOte; 01-02-2010 at 06:45 AM. Reason: changed delimiter to ; per OP
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Thanks for the replies.
DonkeyOte: your formula works as intended - much appreciated.
M/W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks