SUM- hidden rows

  • Thread starter Thread starter Manos
  • Start date Start date
M

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
 
Thanks a lot Frank
IT is quite difficult for me to work with visual but i am
gonna try

Have a nice day
:)
 
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
 
Back
Top