"RagDyeR" wrote...
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", 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*.
....
Which is why the formula above is inadequate. You're also assuming the OP
wants one criterion *OR* the other satisfied. If so, and if they apply
separately to each column, then the OP needs to use something like
=SUMPRODUCT(--((A1:A200="610")+(B1:B200="00")0),D1:D200)
On the other hand, if the OP's '&' in his original attempt should be taken
to mean *BOTH* criteria must be satisfied, then the OP needs to use
=SUMPRODUCT((A1:A200="610")*(B1:B200="00"),D1:D200 )
|