I have a sheet
Amount Item
$12 1
$2 1
$8 3
$98 2
$23 2
the thing I would like to do is
item amount
1 total(amount part is easy, I can use sumif())
2 ***
3 ***

the item part is hard, I tried if(countif()0,item #), but I have 7 items in
total, if I have only 3 items in the colume, I will have 4 empty rows.

A PivotTable would work very nicely here because it would automatically
condense/expand to include the number of different items you need, as well as
summing all the value.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"CC" wrote:

I have a sheet
Amount Item
$12 1
$2 1
$8 3
$98 2
$23 2
the thing I would like to do is
item amount
1 total(amount part is easy, I can use sumif())
2 ***
3 ***

the item part is hard, I tried if(countif()0,item #), but I have 7 items in
total, if I have only 3 items in the colume, I will have 4 empty rows.

To make a pivot table select the data with one row of titles and choose Data,
PivotTable and PivotChart Report, Next, Next, pick the location and choose
Finish. Then put the Item field in the Row area and the Amount field into
the Data area twice. There will be a Data button in the pivot table, drag
this to the blank cell above the word Total. Right-click either of the Sum
of Amount fields and choose Field Setting. Change the calculation from Sum
to Coount.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"CC" wrote:

I have a sheet
Amount Item
$12 1
$2 1
$8 3
$98 2
$23 2
the thing I would like to do is
item amount
1 total(amount part is easy, I can use sumif())
2 ***
3 ***

the item part is hard, I tried if(countif()0,item #), but I have 7 items in
total, if I have only 3 items in the colume, I will have 4 empty rows.