View Single Post
  #3   Report Post  
RagDyeR
 
Posts: n/a
Default

I think you'll have a problem trying to use SumIf() to search *2* columns
(A1:B200).
If "610" and "00" are each in separate columns, (610 in A and 00 in B), then
you'll need 2 "joined" SumIf's:

=SUMIF(A1:A200,"610",D1:D200)+SUMIF(B1:B200,"00",D 1:D200)

If, on the other hand, "610" and "00" are contained in *both* columns, then
you could try something like this:

=SUM(SUMIF(A1:A200,{"610","00"},D1:D200)+SUMIF(B1: B200,{"610","00"},D1:D200)
)

The caveat for both formulas however, is that if "610" and/or "00" are in
the same row, the value in Column D will be totaled *twice*.

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"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