"Bob Phillips" wrote...
If you are trying to test for 2 values, you need 2 SUMIFs
=SUMIF('download worksheet'!,A1:B200,"610",'download worksheet'!D1:D200)
+SUMIF('download worksheet'!,A1:B200,"00,'download worksheet'!D1:D200)
....
Multiple syntax errors, so untested.
Excel's formula parser chokes in the commas immediately after the
exclamation points and the missing double quote after "00.
|