Change summary calculation in Excel

Configurare noua (How To)

Situatie

By default, Excel summarizes your data by either summing or counting the items. To change the type of calculation that you want to use, execute the following steps.

Solutie

Pasi de urmat
  • Click any cell inside the Sum of Amount column.
  • Right click and click on Value Field Settings.

  • Choose the type of calculation you want to use. For example, click Count.

  • Click OK.
  • Result. 16 out of the 28 orders to France were ‘Apple’ orders.

Tip solutie

Permanent

Voteaza

Up Down
(5 din 13 persoane apreciaza acest articol)
Share
Tweet
Share

Despre Autor

Leave A Comment?