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
|