Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table - untick all items in row field | Excel Discussion (Misc queries) | |||
multiple items in database | Excel Worksheet Functions | |||
Computing totals for tax and non-tax items | Excel Worksheet Functions | |||
how do i seperate data from one column into two seperate ones in . | Excel Discussion (Misc queries) | |||
Can't group pivot table items by month in Excel | Excel Discussion (Misc queries) |