sum with multiple criteria

certs

New Member
Joined
Sep 23, 2006
Messages
1
I have 8 years of inventory sales data and i want to have this date in a list and have specific information calculated ie how many sold in that year, in that model, that color, that manufacture ect. i have been searching for a week and so far everything i have tried won't work. "=sum((market="usa")*(Customer="Excel")) seems like the type of function i am looking for but when i enter this example i get an invalid name error. Any help or suggestions would be appreciated. There are 8700 rows and 11 columns. I need to calculate about 6 of those columns into date using what i believe to be a sum function.
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

DominicB

Well-known Member
Joined
Oct 3, 2005
Messages
1,569
Good evening certs

From what you have said, you certainly require the SumProduct function - but if you want someone to write a function for you, you'll have to provide a lot more info about what's in what columns and what sort of criteria you want.

However, if you want to have a go at writing the formulae yourself, you may well benefit from my add-in (via the link below). This has a routine that will help you write that sort of formulae (Ultimate > Formulae > Multile SumIf Generator).

HTH

DominicB
 

GorD

Well-known Member
Joined
Jan 17, 2004
Messages
1,446
I would highly recommend pivot tables ideal for your situation
 

Forum statistics

Threads
1,136,271
Messages
5,674,746
Members
419,525
Latest member
helensesc

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top