wps表格竖列怎么求和

表格中求和是很常用的操作,那么wps表格竖列怎么求和呢?下面就来介绍一下wps表格中竖列求和的两种方法。

工具/原料

  • 遐想Y460
  • Windows7
  • wps office2019

wps表格竖列怎么乞降(要领1)

  1. 1

    打开一个需要竖列乞降的wps表格。

    340e4eb8b43ea8db1510c687189c2cf7deb216f3.jpg?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1%2Fformat%2Cf_auto%2Fquality%2Cq_80
  2. 2

    选中放乞降成果的单位格,单击菜单栏“公式”中的“主动乞降”。

    1f9feadca039131f80b6ef6ce275f2c4ed990af3.jpg?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1%2Fformat%2Cf_auto%2Fquality%2Cq_80
  3. 3

    表格中会主动呈现乞降函数,而且会选中乞降的数据。

    5c2a1ad149299a886249d45067eeadbcbf2f7ff3.jpg?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1%2Fformat%2Cf_auto%2Fquality%2Cq_80
  4. 4

    按下回车键,呈现乞降成果。

    de9bfa3b3b860221290dafe3d8bbf82065fb72f3.jpg?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1%2Fformat%2Cf_auto%2Fquality%2Cq_80END

wps表格竖列怎么乞降(要领2)

  1. 1

    在要放乞降成果的单位格中输入=(等于号)。

    f9617afb960b3121683b3816dee983aee9d76df3.jpg?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1%2Fformat%2Cf_auto%2Fquality%2Cq_80
  2. 2

    在=后输入sum,在提醒信息中双击选择sum函数。

    e996472ae3efe078616be303b96c576698cf65f3.jpg?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1%2Fformat%2Cf_auto%2Fquality%2Cq_80
  3. 3

    选中要乞降的单位格,按回车键。

    988e1c532f6323859d6cde24cce833e038725df3.jpg?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1%2Fformat%2Cf_auto%2Fquality%2Cq_8038332303bbea3e86b5125df65cd4483105eb55f3.jpg?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1%2Fformat%2Cf_auto%2Fquality%2Cq_80
  4. 4

    完当作乞降操作。

    05aae8a75f0f822bf9b42087c018512c8df14df3.jpg?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_500%2Climit_1%2Fformat%2Cf_auto%2Fquality%2Cq_80END
  • 发表于 2023-08-23 18:54
  • 阅读 ( 117 )
  • 分类:其他类型

相关问题

0 条评论

请先 登录 后评论