formula problem I want to calculate monthly balance and per model.

[numfon_naka]

hello everyone
I need to make a Scap app to scale.
But the app has many sheets, in Excel, there are many sheets.
Divided into 4 tables as follows:
1) Model
2) Key (In the app, there is a main table as Main_Key, Key Ref table, find Main_Key table)
3) Quantity
4) Baht

I'm stuck with formula problem in table 2,3.

Table 2 is Quantity. Find the sum of the whole month. but will separate into models
For example, the formula =IF(G$1="","",SUM(KEY!$H$3:$AL$3)*$F3)
G1 = month Jan
H3 = is the beginning of the month / model ( KEY table )
AL3 = is the balance of the end of the month / model ( KEY table )
F3 = is the total
such as
1. Model 9109SS-2 Coil WD
- Month Jan 20, total result 2.60
- Feb 20 got a total of 1.98
"
Until Dec 20 (total of each month, each model
2. Model 9109SS-2 Coil LC
- Month Jan 20, total result 1.06
- Feb 20 got a total of 1.05
"
Until Dec 20 (total balance for each month, each model)

------------------------------------------------------------------------------

Table 3 Baht

For example, the formula: =IF(K$1="","",'SUM(Q''ty)'!K3*$F3).
K1 is the balance of each month in Table 3.Baht
K3 is the amount of each month in the table 2.Quantity
F3 is the total amount in the Unit Price in the 3.Baht table.
1. Model 9109SS-2 Coil WD
- Month Jan 20, total result 778.19
- Feb 20 got a total result of 5041.20
"
Until Dec 20 (total balance for each month, each model)

---------------------------------------------------------------------------------------------------

[Joseph_Seddik]

Using AppSheet, you should avoid doing such calculations in Excel. Instead, you should use AppSheet's own equivalent formulas inside your app, not in the sheet, and keeping your sheets formula-free. 

If, for any reason, you need to keep the formulas in Excel, and you are asking about how to get them right in Excel, then this might not be the best forum to answer your question.