SUM- hidden rows

[Manos]

Dear all
i have some rows which are hidden

When i am using the some function it gives me the sum but
including the hidden rows

There is anyway that to use any function too sum the
ammount without the hidden rows?
It seems funny but i have more than 2000 rows and almost
2500 rows as hidden so it is quite diffictult to go one by
one!

Thanks in advance
Manos

 

[Frank Kabel]

Hi Manos
have a look at the following thread for different solutions
http://tinyurl.com/29aqj

 

[Manos]

Thanks a lot Frank
IT is quite difficult for me to work with visual but i am
gonna try

Have a nice day

 

[Frank Kabel]

Hi Manos
you may have a look at
http://www.mvps.org/dmcritchie/excel/getstarted.htm
for some starting information

 

[Ken Wright]

Manos - You didn't say how your cells had been hidden. If you have hidden them
by use of a filter, then you can simply use the SUBTOTAL function to sum only
visible rows. If you have Excel 2003 then you can use SUBTOTAL to ignore even
manually hidden rows by using the new arguments they introduced in that version,
eg:-

=SUBTOTAL(9,A1:A1000) will only add the visible rows in Col A, if the other have
been hidden by a filter such as Data / Filter / Autofilter