summarize

[PBark]

I have a question. I have a column with only the figure 1, but many. Some are
hidden (invisible) and some are not. What I want to do is to summurize the
figures that you can see on the screen, and note the hidden ones. So lets say
I have 4 figures that are not hidden and 2 which is. In total a have 6
figures but I only wish to have the sum for the 4 figures that are not
hidden. Beacuse all figures are 1, the sum should be 4 and not 6. How can I
solve this? Can you help me?

 

[Bob Phillips]

How are they hidden? Is the data filtered, conditionally formatted, rows
hidden, or what?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[CLR]

If your values are hidden by virtue of being filtered, then this will work....

=SUBTOTAL(9,A:A)


Vaya con Dios,
Chuck, CABGx3

 

[Don Guillett]

look here
http://tinyurl.com/kvuet
http://groups.google.com/group/micr...sum+insubject:visible&rnum=1#5eae090f37f49aaa