Complicated Sum

[vikshrasss]

I have created and attached a sample spreadsheet so it will be easier to read this.
This sheet will have X number of entries. My goal is to get pretty much all the totals. For example Sum of all entries with criteria - Type:Normal, Product: Bread, Shop: Asda.
Do I need a database or is it somehow possible to make this less complicated ? If so, How would you go about in Access for this ? I'm happy to rearrange stuff, or have some multiple sheets(but not for every entry). Any suggestions ?
Thanks

[Sam Capricci]

The best way is difficult to determine based on your attachment.
If you have summary data (amounts for each based on shops and types) in another sheet you can use concatenations and sum based on those. If you put it in access you can base sums on the shops, products and types there. Without more to go on it might be hard to come up with a good solution, from my standpoint anyway.

[Norie]

There's no data in the workbook.

[vikshrasss]

I'm aware there is no data. Data will be added manually entry by entry. I will need to get the totals after that.
Thanks

[:) Sixthsense :)]

Just explain why you are keeping three sections since almost all the headers are same the TYPE.

Just allot a separate column for Type and enter the type data in it and keep the data continuous without and blank rows and repeated headers and merged cells. So that the data can be pulled easily by using any methods like vba code or formula's.

[Norie]

If there's no data how can we suggest formulas to use to summarize the data?