-
Solved: More on SumProduct
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
-
=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))
-
Thank you, worked like a charm
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules