Countif by match two columns

[Haz]

Hi

I am trying to match 2 cells in different cols and then sum the adjcent cols
up.

In A2 i have A002 I would like to find this in Col G then sum d2 and
subtract this from j2 if there is a match.

Any help would be appreciated.

Thanks

 

[ryguy7272]

=SUMPRODUCT(--(A1:A13=A2),--(G1:G13=A2),D113)


See this for more examples:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html


Regards,
Ryan--

 

[Buzz Local#30]

Hey I am doing almost the same as what you are doing here is the code I am
using
=SUMIF('Weekly Entry'!D10,C7,'Weekly Entry'!O23:O24)
I am using 2 difrent sheets to gather my info and I am match D10 to C7 on 2
diferent sheets and if it does match it basicaly copies another sum total on
the weekly sheet