JimS
11-03-2010, 12:54 PM
The following Array Formula works perfect:
{=SUM(IF(FREQUENCY(IF(Status="Won",IF(OppN<>"",MATCH(OppN,OppN,0))),ROW(OppN)-ROW(Cell2)+1),PSRev))}
It currently looks for all the records in my dataset that have a Status = "Won".
Can it be modified to look for 2 different Statuses? I need it to sum if the Status is = "Won" or if the staus is = "Booked".
Something like the following formula (but this formula sums "all" of the records):
{=SUM(IF(FREQUENCY(IF(OR(Status="Won",Status="Booked"),IF(OppN<>"",MATCH(OppN,OppN,0))),ROW(OppN)-ROW(Cell2)+1),PSRev))}
I tried a "and" in place of the "or" but that didn't work at all.
Any ideas?
Thanks...
JimS
{=SUM(IF(FREQUENCY(IF(Status="Won",IF(OppN<>"",MATCH(OppN,OppN,0))),ROW(OppN)-ROW(Cell2)+1),PSRev))}
It currently looks for all the records in my dataset that have a Status = "Won".
Can it be modified to look for 2 different Statuses? I need it to sum if the Status is = "Won" or if the staus is = "Booked".
Something like the following formula (but this formula sums "all" of the records):
{=SUM(IF(FREQUENCY(IF(OR(Status="Won",Status="Booked"),IF(OppN<>"",MATCH(OppN,OppN,0))),ROW(OppN)-ROW(Cell2)+1),PSRev))}
I tried a "and" in place of the "or" but that didn't work at all.
Any ideas?
Thanks...
JimS