summarize
 

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?

summarize
 

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)

"PBark" wrote in message
...
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?

summarize
 

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

=SUBTOTAL(9,A:A)


Vaya con Dios,
Chuck, CABGx3



"PBark" wrote:

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?

summarize
 

look here
http://tinyurl.com/kvuet
http://groups.google.com/group/micro...090f37f49aa a

--
Don Guillett
SalesAid Software

"PBark" wrote in message
...
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?