| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count a specific month in a column
Help,
Been working on this spreadsheet and it is starting to drive me Mad, I am trying to count a column which it contains text and numbers, I am trying to count every cell that contains the month July with no success. I have tried wild cards and a pivot table, this give me a total of 6 when there is only 4. What am I doing wrong - please help -- Thanks for your support Elaine |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count a specific month in a column
Maybe something like this
=COUNTIF(A1:A5,"july") "Elaine" wrote: Help, Been working on this spreadsheet and it is starting to drive me Mad, I am trying to count a column which it contains text and numbers, I am trying to count every cell that contains the month July with no success. I have tried wild cards and a pivot table, this give me a total of 6 when there is only 4. What am I doing wrong - please help -- Thanks for your support Elaine |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count a specific month in a column
Hi Mike
I have tried that it appears as zero, so I tried it with as a wildcard and no no luck still appears as zero All the column has is this: 17/07/2008 15/07/2008 18/02/1900 18/02/1900 07/07/2008 18/02/1900 04/07/2008 Trying to pull out the number of July Performance reviews -- Thanks for your support Elaine "Mike" wrote: Maybe something like this =COUNTIF(A1:A5,"july") "Elaine" wrote: Help, Been working on this spreadsheet and it is starting to drive me Mad, I am trying to count a column which it contains text and numbers, I am trying to count every cell that contains the month July with no success. I have tried wild cards and a pivot table, this give me a total of 6 when there is only 4. What am I doing wrong - please help -- Thanks for your support Elaine |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count a specific month in a column
Try this:
=SUMPRODUCT((MONTH(A1:A7)=7)*(YEAR(A1:A7)=2008)) Hope this helps. Pete On Jul 1, 1:30*am, Elaine wrote: Hi Mike I have tried that it appears as zero, so I tried it with as a wildcard and no no luck still appears as zero All the column has is this: 17/07/2008 15/07/2008 18/02/1900 18/02/1900 07/07/2008 18/02/1900 04/07/2008 Trying to pull out the number of July Performance reviews -- Thanks for your support Elaine "Mike" wrote: Maybe something like this =COUNTIF(A1:A5,"july") "Elaine" wrote: Help, Been working on this spreadsheet and it is starting to drive me Mad, I am trying to count a column which it contains text and numbers, I am trying to count every cell that contains the month July with no success. I have tried wild cards and a pivot table, this give me a total of 6 when there is only 4. What am I doing wrong - please help -- Thanks for your support Elaine- Hide quoted text - - Show quoted text - |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count a specific month in a column
Thanks
Pete got it before I got your message, have now added the year on, working perfectly now -- Thanks for your support Elaine "Pete_UK" wrote: Try this: =SUMPRODUCT((MONTH(A1:A7)=7)*(YEAR(A1:A7)=2008)) Hope this helps. Pete On Jul 1, 1:30 am, Elaine wrote: Hi Mike I have tried that it appears as zero, so I tried it with as a wildcard and no no luck still appears as zero All the column has is this: 17/07/2008 15/07/2008 18/02/1900 18/02/1900 07/07/2008 18/02/1900 04/07/2008 Trying to pull out the number of July Performance reviews -- Thanks for your support Elaine "Mike" wrote: Maybe something like this =COUNTIF(A1:A5,"july") "Elaine" wrote: Help, Been working on this spreadsheet and it is starting to drive me Mad, I am trying to count a column which it contains text and numbers, I am trying to count every cell that contains the month July with no success. I have tried wild cards and a pivot table, this give me a total of 6 when there is only 4. What am I doing wrong - please help -- Thanks for your support Elaine- Hide quoted text - - Show quoted text - |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count a specific month in a column
You're welcome, Elaine - thanks for feeding back.
Pete On Jul 1, 1:55*am, Elaine wrote: Thanks Pete got it before I got your message, have now added the year on, working perfectly now -- Thanks for your support Elaine |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count a specific month in a column
Got it to work by using =SUMPRODUCT(--(TEXT(C12:C18,"mmm")="Jul"))
-- Thanks for your support Elaine "Mike" wrote: Maybe something like this =COUNTIF(A1:A5,"july") "Elaine" wrote: Help, Been working on this spreadsheet and it is starting to drive me Mad, I am trying to count a column which it contains text and numbers, I am trying to count every cell that contains the month July with no success. I have tried wild cards and a pivot table, this give me a total of 6 when there is only 4. What am I doing wrong - please help -- Thanks for your support Elaine |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count a specific month in a column
or...
=SUMPRODUCT(--(month(C12:C18)=7)) or for a given year: =SUMPRODUCT(--(TEXT(C12:C18,"yyyymm")="200807")) Elaine wrote: Got it to work by using =SUMPRODUCT(--(TEXT(C12:C18,"mmm")="Jul")) -- Thanks for your support Elaine "Mike" wrote: Maybe something like this =COUNTIF(A1:A5,"july") "Elaine" wrote: Help, Been working on this spreadsheet and it is starting to drive me Mad, I am trying to count a column which it contains text and numbers, I am trying to count every cell that contains the month July with no success. I have tried wild cards and a pivot table, this give me a total of 6 when there is only 4. What am I doing wrong - please help -- Thanks for your support Elaine -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count occurance of a month in a column of dates? | Excel Worksheet Functions | |||
| count number of dates in a column that are within a month period.. | Excel Worksheet Functions | |||
| Formula to count month-specific items | Excel Discussion (Misc queries) | |||
| URGENT: Search for text in column and count by month | Excel Discussion (Misc queries) | |||
| SUM/COUNT column(s) based on specific value present within the column | Excel Worksheet Functions | |||
Hybrid Mode
