Sumproduct additional criterias

[lacosta]

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.

[Don Guillett]

Can't you use the same { } idea

--
Don Guillett
SalesAid Software
[email protected]
"lacosta" <[email protected]> wrote in
message news:[email protected]...
>
>
>
> 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.
>
>
> --
> lacosta
> ------------------------------------------------------------------------
> lacosta's Profile:
http://www.excelforum.com/member.php...o&userid=15519
> View this thread: http://www.excelforum.com/showthread...hreadid=473519
>

[lacosta]

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