Find a range of numbers in a column with hidden cells

[Jlyons]

I have a list of clients and I am trying to see how many clients I have in multiple ranges of premiums. For example: how many clients do i have with premium between 5,000 and 10,000. The issue that I'm having is that the column I'm trying to calculate from has hidden cells so I think my range calculation is also calculating those hidden cells. How can I calculate a range with a column that has hidden cells?

Thanks for any help

 

[JamesCanale]

Excel's SUBTOTAL function can be made to ignore hidden cells.

=SUBTOTAL(109,C42:I42)

The '109' is the SUM function that excludes hidden cells.

Subtotal can do a number of other functions apart from 'add' too.