I am working with a dataset consisting of email addresses, blank spaces, dates, and various other information. I am using a SumProduct that checks a Date column, ensuring that the date is no earlier than the present day, and also checks an email column to ensure that there is an email address there. I need a count of the total email addresses in a specific column based on the date. The formula I'm using now returns the #value! error:
C43 is the date that the table was last updated in the numeral form (6/19/2018 = 43270). Overall_Pop_Date is a dynamic range that looks as so:
Overall_Pop_TPA is another dynamic range that is used to help define the range where the email addresses will fall:
The table of dates and email addresses will be added to and lengthened which is why the dynamic range is necessary.
I believe the error is coming from the blank cells in the column after the search operation is performed. With a blank cell, the search operation would return an error value. I thought the isnumber operator would fix this, reading the error as false, which is why I'm stumped.
PS: I can't provide the data table as it would be a violation of our privacy practices, however I'm happy to describe the table in more detail.
Bookmarks