Take a look at the attached sheet - in Cell H3 I have entered a formula to calculate the total nett cost.
Is it possible for this formula to automatically update when you apply filters?
Take a look at the attached sheet - in Cell H3 I have entered a formula to calculate the total nett cost.
Is it possible for this formula to automatically update when you apply filters?
See SUBTOTAL function in XL Help, eg:
=SUBTOTAL(9,H5:H102)
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks