« previous next »
Pages: [1]

Author Topic: can excel formular sum only filter data  (Read 1446 times)

徐雪峰

  • Pro Enterprise
  • Newbie
  • *
  • Posts: 48
    • View Profile
can excel formular sum only filter data
« on: August 08, 2020, 07:32:28 pm »
i want write a excel formular to sum a column's data,but the summary don't include the hidden cells of the column.
is there any way to do it?
Logged

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6309
    • View Profile
Re: can excel formular sum only filter data
« Reply #1 on: August 10, 2020, 10:37:40 am »
Please try

Code: [Select]
filterModel: { hideRows: true },
Logged
Pages: [1]
« previous next »