Excel Tables

[lzweifel]

Hello,

I would like to compile my data into a table where I can sort more efficiently... the problem I am faced with is that I have two categories, I think... what I am sorting through are parts so there are part numbers/serial numbers/cost etc... however there are a few categories of parts, so I would like to be able to compile parts within their category as well as all together... I would also like to be able to have dollar totals for the entire list as well as for each category.

I have search for answers, but because I am probably not describing it properly I am not finding exactly what I need.

Thanks in advance for your help,

 

[Rijnsent]

Hi lzweifel,
for the sorting: if you use Custom Sort in the menu (in the Sort&Filter menu), you could create various sort levels: so first sort by Category, after that by Part Number. For your totals: there are two ways: 1) create a small table yourself with SUMIFS formulas to add up all the values you need (e.g. for one category) or 2) select your table as a source for a Pivot Table and get the totals in that way.
Hope that helps,
Koen

 

[EricMBA]

Hi lzweifel,
for the sorting: if you use Custom Sort in the menu (in the Sort&Filter menu), you could create various sort levels: so first sort by Category, after that by Part Number. For your totals: there are two ways: 1) create a small table yourself with SUMIFS formulas to add up all the values you need (e.g. for one category) or 2) select your table as a source for a Pivot Table and get the totals in that way.
Hope that helps,
Koen

You can also group by category and part number with subtotals.