Summing without Hidden cells' content

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view

Summing without Hidden cells' content

GnuMeric mailing list
Hi all,

As a first post,

Can someone please explain how i can sum the content of a column of
cells without including values of hidden cells ?

The column is auto filtered to hide some not applicable values.
Currently =sum() includes all the values in the column.

Perhaps I'm missing a trick ?

Thanks, Mike

gnumeric-list mailing list
[hidden email]