Hi!
I'm currently working with a file that I'm trying to use to sum unique customer numbers based on two separate criteria: month (listed in a column the same tab as the customer id data and month indicated by a number i.e. 4 = April) and product type (A or B which is pulled from a tab in which the data is not typed in text but is a result of a vlookup from a different tab--therefore, the value is a result of a vlookup rather than a hardcoded value).
I am using the following formula to sum the unique customer ids in April, which is working fine:
=SUMPRODUCT(1/COUNTIF(Data!Y:Y,Data!Y2:Y2500),--((Data!B2:B2500=4))) --> Customer ID in Data tab column Y and Month number in Column B.
I am usin gthe same forumla as follows to try to sum the unique customer IDs who purchased product category A:
=SUMPRODUCT(1/COUNTIF(Data!Y:Y,Data!Y2:Y2500),--((Data!I2:I2500="A"))) --> Customer ID in Data tab column Y and Product category A/B in Column I (but result of Vlookup from separate tab).
I'm erroring out with a #N/A.
Is it because I need a different formula or because my product category I'm pulling is based on a vlookup? Anyone have a solution they can help with?
Thanks!
Bookmarks