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

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

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

Try this:

=SUMPRODUCT((MONTH(A1:A7)=7)*(YEAR(A1:A7)=2008))

Hope this helps.

Pete

On Jul 1, 1:30*am, Elaine <Ela...@discussions.microsoft.com> 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, Iam
> > > 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 -

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

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

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 <Ela...@discussions.microsoft.com> 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 -
>
>

You're welcome, Elaine - thanks for feeding back.

Pete

On Jul 1, 1:55*am, Elaine <Ela...@discussions.microsoft.com> wrote:
> Thanks
> Pete got it before I got your message, have now added the year on, working
> perfectly now
> --
> Thanks for your support
> Elaine
>
>