Sumproduct additional criterias

  • Thread starter Thread starter lacosta
  • Start date Start date
L

lacosta

:confused:

Hello All,

Earlier, Aladin helped me with my formula but now I need to expand it
and I have tried a few ways but the results are not correct. The
formula that worked previously was as followed:

SUMPRODUCT(--([March2005LockDate.xls]Create!$F$1:$F$50418="Retail
PA"),--ISNUMBER(MATCH([March2005LockDate.xls]Create!$K$1:$K$50418,{"Conf10","Conf15"},0)))

Now, I need to add additional criterias. In addition to Retail PA, I
also Need Retail CT and Retail IL. I also have to add a complete new
string that will take into consideration status which will be "Closed",
"Declined", "Withdrawn" and "Expired"

Please let me know how I can achieve this.

Thanks.
 
I tried using the {} idea and that din't work. When I used it I go
results that were not accurate so I am probably using it wrong
 
Back
Top