Dundee Lad
Active Member
- Joined
- Sep 6, 2003
- Messages
- 311
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!
= 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!