Subtotals or PivotTables

[Peter]

In the following example:

For Item "a": I need subtotals of $418.38 for "CA", $67.78
for "NV" and $97.70 for "AZ" plus the total of $583.86.

For Item "b": I need subtotals of $202.16 for "ME", $33.90
for "VT" and $48.84 for "OK" plus the total of $284.90.

Item State Price
a CA 81.08
a CA 82.70
a CA 83.68
a CA 84.62
a CA 86.30
a NV 13.54
a NV 13.56
a NV 13.56
a NV 13.56
a NV 13.56
a AZ 19.54
a AZ 19.54
a AZ 19.54
a AZ 19.54
a AZ 19.54
b ME 39.18
b ME 39.96
b ME 40.44
b ME 40.88
b ME 41.70
b VT 6.78
b VT 6.78
b VT 6.78
b VT 6.78
b VT 6.78
b OK 9.78
b OK 9.76
b OK 9.78
b OK 9.76
b OK 9.76

Using my example, please give me step-by-step
instructions.

Thanks

Peter

 

[Ken Wright]

Please don't multipost. As per answer in worksheet.functions:-

Using Pivot tables - You don't say what version so instructions may differ
slightly:-

Highlight your data - headers as well and then do Data / PivotTable and
PivotChart Report
Hit Next
Hit Next
Hit Finish

You will now see a blank table on the worksheet and a floating dialog box called
PivotTable Field List with 3 items in it, namely your headers:-

Drag ITEM to the far left of the blank table
Drag STATE to just between the ITEM field and the blank area in the middle.
Drag PRICE into the big blank area in the middle

Job Done