[Solved] How to sum data from an order tab to a order type tab

[xjustdman]

Hi,

I have data on the order tab, order number, category code, then by store, a category code could be used multiple times. I then need to calculate the total by each store and category code on the By Type tab. I cant use a pivot as the real table has budget and other numbers feeding that wont be on the order tab. Is it possible to do this as a formula?

 

[shamimarita]

Hello,

You can easily summarize data from your Order tab into the Order Type tab using the SUMIFS function.

Use this formula in the yellow summary table (for cell C5 where Store = 1 and Category = a):
=SUMIFS('Order'!C$3:C$8, 'Order'!$B$3:$B$8, C$4)

• Then adjust for each column (store) and row (category).
• If your source store data starts from column C and ends at H (Store 1 to 6), you can fill this pattern:

Summary Cell	Formula Example
C5 (Store 1 & Category a)	=SUMIFS(Order!C$3:C$8, Order!$B$3:$B$8, $B5)
D5 (Store 2 & Category a)	=SUMIFS(Order!D$3$8, Order!$B$3:$B$8, $B5)
E6 (Store 3 & Category b)	=SUMIFS(Order!E$3:E$8, Order!$B$3:$B$8, $B6)