Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have an Excel sheet where I sum hours to get the total amount of my work.

It works without problems, but if I add an automatic filter I'd like the calculations to be done only on the portion of data shown by the filter – and right now it keeps on counting, even the hours "hidden" by the automatic filter.

Is there any way to obtain this?

I'd like to use plain Excel, without programming and VBA scripts.

Probably the question lacks of details, but if someone with more expertise can help with comments to improve the question I'll be glad to do it.

share|improve this question
Probably a screen shot or the formulas you use could help — it's always good to have these for Excel questions! – slhck Aug 24 '11 at 14:57
up vote 4 down vote accepted

Use the SUBTOTAL() function with the 9 option:

=SUBTOTAL(9, yourrange)
share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.