I have about 500 sales entries. Using autosort, I pull out all
Mondays
(they are scattered though out the 500)
I want then to count then number of Monday entries, but the formula
counts all and my result is 500. I know this is explained poorly.
Thanks

Your explanation would be better if you included the formula and your Excel version.
Also, consider providing a response to those who answer your questions.
--
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware
(free and commercial excel programs)




"Skip" <(E-Mail Removed)>
wrote in message
news:d468a3e8-65f6-4eed-8258-(E-Mail Removed)...
>I have about 500 sales entries. Using autosort, I pull out all
> Mondays
> (they are scattered though out the 500)
> I want then to count then number of Monday entries, but the formula
> counts all and my result is 500. I know this is explained poorly.
> Thanks

I believe you mean autofilter, not autosort.

Check out help on the SUBTOTAL function for working with filtered ranges.

e.g. for counting use argument of 2

=SUBTOTAL(2,range)


Gord Dibben MS Excel MVP


On Tue, 8 Mar 2011 05:28:51 -0800 (PST), Skip <(E-Mail Removed)> wrote:

>I have about 500 sales entries. Using autosort, I pull out all
>Mondays
>(they are scattered though out the 500)
>I want then to count then number of Monday entries, but the formula
>counts all and my result is 500. I know this is explained poorly.
>Thanks

"Skip" <(E-Mail Removed)> wrote in message
news:d468a3e8-65f6-4eed-8258-(E-Mail Removed)...
>I have about 500 sales entries. Using autosort, I pull out all
> Mondays
> (they are scattered though out the 500)
> I want then to count then number of Monday entries, but the formula
> counts all and my result is 500. I know this is explained poorly.
> Thanks

I understand what you mean. My spreadsheet contains 40 Columns and over
8000 Rows of data.

Assuming the day is in Column B and Row 1 contains headings, use:
=COUNTIF(B2:B500,"Monday"). This counts the number of times "Monday" occurs
in a column but assumes only one transaction for that day. If you have
several transactions for a Monday (recorded in another column, say Column C)
I suggest you use =Sumif(A2:C500,"Monday",C2:C500) where:

A2:A500 defines the database under consideration;
"Monday" defines the criteria - it must be in the first column of the part
of the database under consideration;
C2:C500 defines the column to be added where the entry in Column A is
"Monday".

Note: If Column D contains the transaction value you can get the total of
sales for Mondays using =Sumif(A2500,"Monday",D2500). Refer to the help
section.