H ithere,

Can someone please help me? I have a column which can only have
option (due to validation), these are:-
New
Overdue
Updated
Closed


I would like to count the number of times each one has been entered.
Each count would be in a different cell on a different worksheet.
have tried searching this forum and found answers similar to what i'
looking for but i could not get any of them to work for some reason?

Thanks very much for your time.

Swmasso

--
Message posted from http://www.ExcelForum.com

Hi

you need to use the countif function for this
so if your range is on sheet 1 A1:A10
then on sheet2 in cell
A1 use
=COUNTIF(Sheet1!A1:A10,"New")
etc

Let us know how you go.

Cheers
JulieD


"swmasson >" <<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> H ithere,
>
> Can someone please help me? I have a column which can only have 4
> option (due to validation), these are:-
> New
> Overdue
> Updated
> Closed
>
>
> I would like to count the number of times each one has been entered.
> Each count would be in a different cell on a different worksheet. I
> have tried searching this forum and found answers similar to what i'm
> looking for but i could not get any of them to work for some reason?
>
> Thanks very much for your time.
>
> Swmasson
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>

Hi there again,

I managed to figure out after searching the forum a bit longer, ver
easy -


=COUNTIF(J:J,"Updated")


And so on..............

--
Message posted from http://www.ExcelForum.com

Hi

glad you figured it, however, if you're performing the countif in another
sheet from where the data is you need to include the sheet name in front of
the range name
e.g.
=COUNTIF(Sheet1!J:J,"Updated")

Cheers
JulieD

"swmasson >" <<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi there again,
>
> I managed to figure out after searching the forum a bit longer, very
> easy -
>
>
> =COUNTIF(J:J,"Updated")
>
>
> And so on...............
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>