Summing One Column based on Multiple Other Columns

[Dundee Lad]

This is my formula below. I had some help from Rorya & Aladyn with this earlier. I am using Excel 2003

= SUMPRODUCT(--('Campaign List'!$J$1:$J$49949="TM"),--('Campaign List'!$A$1:$A$49949=Summary!B19),1-ISNUMBER('Campaign List'!$V$1:$V$49949),'Campaign List'!$G$1:$G$49949)

I now need to add another check into this I need to check if column I is XZ, along with column j being TM and it equalling Summary!B19 then sum column G as long as there is no number in column V

Hope this all makes sense!

 

[xld]

= SUMPRODUCT(--('Campaign List'!$I$1:$I$49949="XZ"),--('Campaign List'!$J$1:$J$49949="TM"),
--('Campaign List'!$A$1:$A$49949=Summary!B19),--ISNUMBER('Campaign List'!$V$1:$V$49949),
'Campaign List'!$G$1:$G$49949)

 

[Dundee Lad]

thank you