[Skip[_2_]]

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

[Jim Cone[_2_]]

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

[Gord Dibben[_2_]]

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 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

[David8]

"Skip" wrote in message
...
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) whe

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(A2:D500,"Monday",D2:D500). Refer to the help
section.