software

I now have all of my info on one line. I can get it to sort.
How do I get a count of only the stores, that filtered to the
criteria?
How do I get a total number of circulars needed for those stores?--
CBrausa
------------------------------------------------------------------------
CBrausa's Profile: www.excelforum.com/member.php...oamp;userid=24677
View this thread: www.excelforum.com/showthread...hreadid=519797Assuming your data (before filtering) is in A2:100, enter formula:
=SUBTOTAL(3,A2:A100)

HTH
--
AP

quot;CBrausaquot; gt; a écrit
dans le message de
...
gt;
gt; I now have all of my info on one line. I can get it to sort.
gt; How do I get a count of only the stores, that filtered to the
gt; criteria?
gt; How do I get a total number of circulars needed for those stores?
gt;
gt;
gt; --
gt; CBrausa
gt; ------------------------------------------------------------------------
gt; CBrausa's Profile:
www.excelforum.com/member.php...oamp;userid=24677
gt; View this thread: www.excelforum.com/showthread...hreadid=519797
gt;
Not real sure of your situation, but the SUBTOTAL(YourRange,2) feature will
count rows in a filtered output and ignore the hidden ones.........

Vaya con Dios,
Chuck, CABGx3
quot;CBrausaquot; wrote:

gt;
gt; I now have all of my info on one line. I can get it to sort.
gt; How do I get a count of only the stores, that filtered to the
gt; criteria?
gt; How do I get a total number of circulars needed for those stores?
gt;
gt;
gt; --
gt; CBrausa
gt; ------------------------------------------------------------------------
gt; CBrausa's Profile: www.excelforum.com/member.php...oamp;userid=24677
gt; View this thread: www.excelforum.com/showthread...hreadid=519797
gt;
gt;


Thanks for the help. It works. --
CBrausa
------------------------------------------------------------------------
CBrausa's Profile: www.excelforum.com/member.php...oamp;userid=24677
View this thread: www.excelforum.com/showthread...hreadid=519797