Summing a whole coulmn to a single cell depending on the status

I am making an app to manage my small business
i am having three views current orders , shipped orders , and finished orders
i need to calculate my total order price to get current and finished and i donโ€™t know how to do it
my first approach is to dedicate the first to lines in the sheet to that .
is there is a better approach

0 2 105
2 REPLIES 2

I advise you to create a form with the chart type.
In it you can not only see the total values, but also filter them by different parameters.
For exmpl

Steve
Platinum 4
Platinum 4

See the examples here:

Top Labels in this Space