When calculating the sum of a range that you will be applying filtering to, you will want to use the SUBTOTAL function. SUBTOTAL will ignore any hidden rows of data aka filtered data.
Shamsu R.
asked • 01/20/23which of the following functions can be use to calculate the total sum of a filtered value
Follow
•
1
Add comment
More
Report
1 Expert Answer
Still looking for help? Get the right answer, fast.
Ask a question for free
Get a free answer to a quick problem.
Most questions answered within 4 hours.
OR
Find an Online Tutor Now
Choose an expert and meet online. No packages or subscriptions, pay only for the time you need.
