View Single Post
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

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)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Basil" wrote in message
...
Hi, I need assistance with a download that has text in two seperate

columns,
referencing general ledger account numbers. I need to reference these
columns in a sumif formula, but can't seem to get it right.
This is an example:
sumif(download worksheet a1:b200,"'610'"&"'00'",downloadworksheet d1:d200)

Any ideas?
Thanks