Current location - Health Road Network - Medical equipment enterprise - The project equipment purchase contract account managed by EXCEL forms wants to filter out the contract amounts of public works and sum them up. How to do this?

The project equipment purchase contract account managed by EXCEL forms wants to filter out the contract amounts of public works and sum them up. How to do this?

suppose that the items in the table (i.e. those containing public works) are in column B, the contract amount is in column D, and 9 contracts have been entered;

enter =SUBTOTAL(19,D2:D1) in the last cell of column d (for example, D11), and when you continue to enter the contract in the future, you can insert the line at any time before the 1th line.

set automatic filtering, utilities-custom-include-utilities.

the figure in p>D11 is the sum of all contract amounts including public works.

Related articles