Add seperate Items.
 

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

Add seperate Items.
 

Hello from Steved

Below is giving me 16 but there is only 8.

=SUMPRODUCT(--('Paradox-Kilometres'!$E$1:$E$4999="City
Depot"),--(TRIM('Paradox-Kilometres'!$D$1:$D$4999)="99MERC-0305-3AX"))

Is their another formula I could use, that will give me the desired result.

City Depot is in Column E
99MERC-0305-3AX is in column D
How many 99MERC-0305-3AX are there in Column D Totalling City Depot in
Column E

Thankyou.



"Steved" wrote:

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

Add seperate Items.
 

Your post is a little confusing. By "adding" the products associated with a
city, do you mean count them? If so, use:

=SUM(--('Paradox-Kilometres'!$D$1:$D$4999={"99MERC-0305-3AX","00MERC-0305-3AX"})*('Paradox-Kilometres'!$E$1:$E$4999="City Depot"))

If you actually mean sum a set of numbers in another column (say col. C)
associated with specific products and cities, use:

=SUM(IF(('Paradox-Kilometres'!$D$1:$D$4999={"99MERC-0305-3AX","00MERC-0305-3AX"})*('Paradox-Kilometres'!$E$1:$E$4999="City
Depot"),'Paradox-Kilometres'!$C$1:$C$4999))

Both formulas are array-entered (press ctrl + shift + enter).

HTH
Jason
Atlanta, GA


"Steved" wrote:

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

Add seperate Items.
 

Hello From Steved

I'm trying to find how many off the below in column D, With the place names
in Column E ie City, Roskill etc. so in the 99MERC-0305-3AX, 00MERC-0305-3AX
is found 8 times, in City, 12 in Roskill.
99MERC-0305-3AX
99MERC-0305-3AX

"Jason Morin" wrote:

Your post is a little confusing. By "adding" the products associated with a
city, do you mean count them? If so, use:

=SUM(--('Paradox-Kilometres'!$D$1:$D$4999={"99MERC-0305-3AX","00MERC-0305-3AX"})*('Paradox-Kilometres'!$E$1:$E$4999="City Depot"))

If you actually mean sum a set of numbers in another column (say col. C)
associated with specific products and cities, use:

=SUM(IF(('Paradox-Kilometres'!$D$1:$D$4999={"99MERC-0305-3AX","00MERC-0305-3AX"})*('Paradox-Kilometres'!$E$1:$E$4999="City
Depot"),'Paradox-Kilometres'!$C$1:$C$4999))

Both formulas are array-entered (press ctrl + shift + enter).

HTH
Jason
Atlanta, GA


"Steved" wrote:

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

Add seperate Items.
 

Thanks Jason

It's done as what you wrote.

Cheers

"Jason Morin" wrote:

Your post is a little confusing. By "adding" the products associated with a
city, do you mean count them? If so, use:

=SUM(--('Paradox-Kilometres'!$D$1:$D$4999={"99MERC-0305-3AX","00MERC-0305-3AX"})*('Paradox-Kilometres'!$E$1:$E$4999="City Depot"))

If you actually mean sum a set of numbers in another column (say col. C)
associated with specific products and cities, use:

=SUM(IF(('Paradox-Kilometres'!$D$1:$D$4999={"99MERC-0305-3AX","00MERC-0305-3AX"})*('Paradox-Kilometres'!$E$1:$E$4999="City
Depot"),'Paradox-Kilometres'!$C$1:$C$4999))

Both formulas are array-entered (press ctrl + shift + enter).

HTH
Jason
Atlanta, GA


"Steved" wrote:

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