Solved: More on SumProduct

[JKwan]

I have this formula:
[vba]
=SUMPRODUCT(--(PivotSource!$R$2:$R$642<>"N/A")*((PivotSource!$R$2:$R$642="High Level")+(PivotSource!$R$2:$R$642="Low Level")+(PivotSource!$R$2:$R$642="High Pressure")+(PivotSource!$R$2:$R$642="Low Pressure")+(PivotSource!$R$2:$R$642="High Temp")+(PivotSource!$R$2:$R$642="Low Temp")+(PivotSource!$R$2:$R$642="Misdirected Flow"))*(PivotSource!$AA$2:$AA$642=$A4))
[/vba]

Is there a way to shorten it? Basically, if I can compare using an array of items, I don't know if SumProduct can do that.

Thanks

[Aflatoon]

=SUMPRODUCT((PivotSource!$R$2:$R$642={"High Level","Low Level","High Pressure","Low Pressure","High Temp","Low Temp","Misdirected Flow"})*(PivotSource!$AA$2:$AA$642=$A4))

[JKwan]

Thank you, worked like a charm