While working in the Excel program, the user may be faced with the need to draw an intermediate result, in addition to the usual general.
The article will consider the table of sales of goods for the month, since most often it is this function that is used for the presented operation. It will look in the form of three columns: the name of the product, date and amount of revenue. Using the "Excel" subtotals, it is possible to calculate the daily earnings of a product. In addition, at the end you can summarize the amount of sales of goods. Now we will consider in detail how the subtotals are made in Excel.
Function Terms of Use
It should immediately be clarified that in order to use the presented operation, the table must meet the requirements. In total, three points should be observed:
, . .
.
""? . , .
1:
" ". "" ( ""). , , "".
2:
, . , " " "".
, "" "". , , . :
, . " " , . , " , .".
: " ", " " " ". , .
3:
"". . , «» . .
.
, "" ? - .
, , , " ". .
1:
, , .
, . " ", . .
, " " "." "". , , "" " ".
2:
, . . " " , :
, "9".
" 1" , . , : . , . , .
, ( ). , "" .