Forum Discussion

Copper Contributor

Aug 22, 2022

Formula auto-update

Hello,

Is there a way to get a formula to auto-update to show only rows that are not hidden when the data set is filtered?

Thank you,

Formulas and Functions

3 Replies

HansVogelaar
MVP
Aug 22, 2022
dubcee

Without knowing details, it's hard to provide specific help, but investigate the SUBTOTAL function and AGGREGATE function
- dubcee
  Copper Contributor
  Aug 22, 2022
  Hi Hans,
  
  I tried to use the aggregate function to return averages and ignore hidden rows but didn't work. Here's what I entered: =AGGREGATE(1,5,A6:K48)
  
  Am I doing something wrong?
  - dubcee
    Copper Contributor
    Aug 22, 2022
    I realized what I did wrong. Thank you for your help!