E
Easypick
I am trying to sum column C if the criteria are met for both A & B. A must
not be equal to X and B must begin with Cash. I have tried using the
wildcard * and --, but I still get an error.
Thanks
Invoice # Client Cost
5678 Cash (Credit Card) 50.00
1234 Acme 100.00
X Cash in Advance 25.00
6541 XYZ Co 10.00
X Cash (Credit Card) 100.00
not be equal to X and B must begin with Cash. I have tried using the
wildcard * and --, but I still get an error.
Thanks
Invoice # Client Cost
5678 Cash (Credit Card) 50.00
1234 Acme 100.00
X Cash in Advance 25.00
6541 XYZ Co 10.00
X Cash (Credit Card) 100.00