Help with Pivot Tables see

videos at
DataPig Excel Training - Mike Alexander
http://www.datapigtechnologies.com/ExcelMain.htm

webpages on Pivot Tables
Debra Dalgleish - Contextures.com
http://www.contextures.com/tiptech.html

---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Serge" wrote in message ...
Hello Herbert,
I have been at my project for over 5 hours this evening with no luck. First
my 63 year old brain is struggling with the pivot table. I have gone back in
my class books & notes about this pivot table. Also I don't understand how
will the pivot table populate A19:B26 in the Summary Sheet.

I'm sorry, I don't get it.

Serge


"Herbert Seidenberg" wrote:

I assume that you want to list in "Summary" all the combinations of
diameters and lengths that appear in "Bolt List", selected by "Grade"
A3
and enabled if "Washer" shows a number.
Pivot Table lets you do that with a lot less formulas.
Assume your simplified data in "Bolts List" looks like this:

Qty Dia Grade Len Washer WashN
20 0.875 A3 1.75 3 1
3 0.375 A3 1.75 2 1
7 1.000 A3 2.75 2 1
10 0.375 A3 1.00 3 1
14 0.750 A3 1.75 2 1
17 0.625 A2 3.00 3 1
22 0.875 A3 2.50 0
7 0.750 A1 3.00 1 1
19 0.500 A3 2.25 1 1
16 1.000 A2 2.50 3 1
13 0.500 A2 1.50 1 1
9 0.750 A1 2.25 1 1
4 0.500 A1 1.50 2 1
20 0.375 A3 1.75 3 1
1 0.250 A3 0.50 0
3 1.000 A2 3.25 3 1
5 0.625 A1 2.00 1 1
18 0.375 A3 1.50 2 1
6 0.875 A3 2.50 2 1
16 0.250 A3 0.50 2 1

WashN is a helper column with this formula:
=--(ISNUMBER(Washer))
Select all of the above data, including headers, and do Pivot Table.
Layout: ROW = drag in Dia, Len, Grade, WashN in that order
COLUMN = (leave empty)
DATA = Sum of Qty
Options: Uncheck grand totals
Uncheck/Hide Subtotals
From Grade dropdown list, select A3.
From WashN dropdown list, select 1.