Using "OR" Function in Sumproduct 1

[DeLaMartre]

Is it possible to use the "OR" function in a Sumproduct logic string. It seems to make sense, but I am having no luck doing this.

For instance: =Sumproduct(((state=$A$1)*(OR(unit=$B$1), (dept=$B$1)))

Any help would be amazing!

Thanks very much,



-Bob in California

 

[SkipVought]

Use two separate sumproduct functions and or the results.

Skip,

_{[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
POULTRY in motion to PULLET for a PALTRY amount!}

 

[DeLaMartre]

Ah, an elegant solution! Thanks so much, Skip; You are a Great Man!

Regards,

-Bob in California