Sub - Subtotals

W

WINS

Can someone please help me out?

I currently have a list of on which I currently have subtotals based on shop
Name, this gives me revenue by shops and total revenues. I am now required to
further show revenue by product type.

Example is set out below;

Shop Product Salesman Amount
AA Electrical SP1 10.00
AA Mechanical SP2 5.00
AA Electrical SP1 10.00
AA Total 25.00

BB Repairs SP4 10.00
BB Electronic SP4 20.00
BB Electronic SP4 10.00
BB Total 40.00

Grand Total 65.00

I would in the present scenario need a subtotal for Electrical and one for
Mechanical within subtotal for Shop AA and same thing for Repairs and
Electronic within subtotal for Shop BB.

Looking forward to receive your bright ideas and possible workaround.
 
S

ShaneDevenshire

Hi,

I think you might consider SUMIF(Product,"Electronic",Amount)

In this example Product represents the range of the product names, and
Amount represents the name of the Amounts range. You can use cell references
instead. Also if you enter Electronic in cell H1 for example then you can
change the formula to read SUMIF(Product,H1,Amount) This way you could list
all the Products in cells H1:H10 and then copy the formula down, wherever you
choose to put it.
 
W

WINS

ShaneDevenshire said:
Hi,

I think you might consider SUMIF(Product,"Electronic",Amount)

In this example Product represents the range of the product names, and
Amount represents the name of the Amounts range. You can use cell references
instead. Also if you enter Electronic in cell H1 for example then you can
change the formula to read SUMIF(Product,H1,Amount) This way you could list
all the Products in cells H1:H10 and then copy the formula down, wherever you
choose to put it.
 
W

WINS

Thks for the sumif function which works out fine, but i still need to report
the sales by rpduct type with shopAA and ShopBB whic make up the Total by
Shops which in turn add up to make up the Grand Total.

The actual data contains more than one hundred such products.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top