Extracting data from a table without pivot

[Henceman]

I have a table, which on worksheet one, I get new data every quarter and based on that I create a pivot, and add extra formulas to gather data from the pivot.

Raw data looks like this: https://imgur.com/a/sCkMsMW

I want to make it simpler, since pivots don`t auto update, and the data I have, is not formatted to use in a pivot right away, since there are empty columns, missing headers etc which makes using pivot without pre-formatting data not possible.

What I expect the formula to do, is sum table by cust reg nr and NR (ET or etc) and provide me with values, just like pivot would, just without the hassle.
Since cust reg. nr are repeating without the table, I think sumif should be used, but how exactly...


So in the end, the moment I insert new data on the worksheet, formulas will scan the table and sum up the total values by customer and classification number (ET) in example.
All without pivots or subtotals.

Is it possible?

Thanks yall.

H.

 

[steve the fish]

Provided those numbers are true numbers then yes a SUMIFS formula would total based on criteria.

 

[Henceman]

But sumifs needs criteria, like customer number, which is gather from actual data, not pre defined.
If I would have say, sales figures per salesman, then yes, the criteria is salesman and I can extract data which is linked with salesman, but right now, it would need to find the unique numbers, sum them up and display.