View Single Post
  #1   Report Post  
Basil
 
Posts: n/a
Default sumif function in excel

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