LinkedIn
Twitter
**
I want to calculate the product balance each month , each year
**
such as
9109F-WD 1/8/2564 = 18
9109F-WD 2/8/2564 = 19
9109F-WD 3/8/2564 = 20
.
9109F-WD 31/8/2564 = 30
Model 9109F-WD Balance of 1 Month Total Date of Recording 81 /Month
If I need information every month I have to create an actual 12 month column and do some calculations, right?
want to calculate product balance /month , /year
But that I use in a formula in Excel of a table called MONTH.
The formula is =IF(ISBLANK(J9),"",MONTH(L9))
J9 = new row picking list
L9 = date of the new row
Itโs a line-by-line calculation. But the result is the number of months.
of the YEAR table as well.
The RP (REPORT) is the yearly summary.
But itโs COUNIF formula, it only counts adding lines, not counting the amount drawn.
I want it to count products by product name.
**
the excel image is an example
**
__________________________________________________________________________
Images from apps and spreadsheets
The formula used for the month
Iโm sorry if I use the wrong word because I use google translate. Iโm not good at language so I have to rely on google translate.
Permission to tag everyone
@Steve @Suvrutt_Gurjar @tsuji_koichi @Alejandra_Petro @Frank_Fischer @Diogo_Portela @PocketDragon @Peter @Bellave_Jayaram @Bill_Bounds
