S
Steved
Hello from Steved
In Paradox-Kilometres worksheet I've got 2 Columns
Column E I've the City ( Place )
Column D I've got the Product
=SUM(IF('Paradox-Kilometres'!$D$1:$D$4999={"99MERC-0305-3AX","00MERC-0305-3AX"},IF('Paradox-Kilometres'!$E$1:$E$4999="City
Depot",'Paradox-Kilometres'!$D$1:$D$4999,0),0))
What I am trying to do is Add the product associated with the City it Belongs
Above is my atttempt, What do I need to do please.
Thankyou
In Paradox-Kilometres worksheet I've got 2 Columns
Column E I've the City ( Place )
Column D I've got the Product
=SUM(IF('Paradox-Kilometres'!$D$1:$D$4999={"99MERC-0305-3AX","00MERC-0305-3AX"},IF('Paradox-Kilometres'!$E$1:$E$4999="City
Depot",'Paradox-Kilometres'!$D$1:$D$4999,0),0))
What I am trying to do is Add the product associated with the City it Belongs
Above is my atttempt, What do I need to do please.
Thankyou