Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count
"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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Employee Work Time - Don't Double-count Overlapping Apts. | Excel Worksheet Functions | |||
Excel 2000, count, sort a list & count totals? | Excel Worksheet Functions | |||
Count Intervals of 2 Consecutive Values in same Row and Return Count across Row | Excel Worksheet Functions | |||
Count Intervals of 2 Numeric values in same Row and Return Count across Row | Excel Worksheet Functions | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions |