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

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

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

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 -

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

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

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 -

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