summarize

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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)
 
If your values are hidden by virtue of being filtered, then this will work....

=SUBTOTAL(9,A:A)


Vaya con Dios,
Chuck, CABGx3
 
Back
Top