Hello everyone,
I have a data collection file with some calculation created. I would like to get my calculations (Column O) to work when I filter the table. How can I get the calculations to work when I filter the table?
Attached here is the file for your references. Appreciate the help and support from you guys here! Thank you so much!
Calculated Values on a Filtered Table
-
-
-
If you format the data as an Excel Table then that feature is built in to the Total Row.
If you use your way then use the SUBTOTAL Function not SUM
-
Hi there,
Thanks! The subtotal function works! -
Pleased to help.
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!