I have a worksheet that we have hidden rows in.  I want to find the sum of a 
column without picking up the hidden row values?  I can I get a sum without 
including the hidden cell values?

What version of Excel are you using?

If you're using Excel 2003 or later try this:

=SUBTOTAL(109,A1:A10)

-- 
Biff
Microsoft Excel MVP


"Tanya" <Tanya@discussions.microsoft.com> wrote in message 
news:3797F36F-B648-469F-8F7B-6E07E5DC837F@microsoft.com...
>I have a worksheet that we have hidden rows in.  I want to find the sum of 
>a
> column without picking up the hidden row values?  I can I get a sum 
> without
> including the hidden cell values? 

Hi,


=SUBTOTAL(109,A1:A6)

change range to fit your needs

"Tanya" wrote:

> I have a worksheet that we have hidden rows in.  I want to find the sum of a 
> column without picking up the hidden row values?  I can I get a sum without 
> including the hidden cell values?