Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

1 Answer 1

up vote 4 down vote accepted

Use the SUBTOTAL() function with the 9 option:

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

Your Answer

 
discard

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.