View Single Post
  #4   Report Post  
Harlan Grove
 
Posts: n/a
Default

"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.