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

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


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


Regards,
Ryan--


--
RyGuy


"Haz" wrote:

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

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
"Haz" wrote in message
...
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