Counting in columns
 

Hi all - I have a column which can include a date (eg format 10 June 2009)
and I want to be able to count the total number of times a date appears in
that column. I also have another column which includes the letter 'y' in
some cells. I also wish to count the total number of 'y's. Can anyone help.
As you can read I am so rubbish at that it is pitiful! Deb

Counting in columns
 

Hope the dates are formatted to excel date format. IF so

=COUNTIF(A:A,DATE(2009,6,10))
will give you the number of dates with 6th June 2009 in Column A

=COUNTIF(A:A,"Y")
will give you the number of Y's in Column A

--
If this post helps click Yes
---------------
Jacob Skaria


"Deb" wrote:

Hi all - I have a column which can include a date (eg format 10 June 2009)
and I want to be able to count the total number of times a date appears in
that column. I also have another column which includes the letter 'y' in
some cells. I also wish to count the total number of 'y's. Can anyone help.
As you can read I am so rubbish at that it is pitiful! Deb

Counting in columns
 

Hi Jacob

The dates are all different. What I need to is to be able to know how many
cells have dates in.

"Jacob Skaria" wrote:

Hope the dates are formatted to excel date format. IF so

=COUNTIF(A:A,DATE(2009,6,10))
will give you the number of dates with 6th June 2009 in Column A

=COUNTIF(A:A,"Y")
will give you the number of Y's in Column A

--
If this post helps click Yes
---------------
Jacob Skaria


"Deb" wrote:

Hi all - I have a column which can include a date (eg format 10 June 2009)
and I want to be able to count the total number of times a date appears in
that column. I also have another column which includes the letter 'y' in
some cells. I also wish to count the total number of 'y's. Can anyone help.
As you can read I am so rubbish at that it is pitiful! Deb

Counting in columns
 

Hi

=count(range_of _dates) will count the number of cells which have dates and
numbers. Since you have not mentioned what else the column can hold, I
assuming that the cells are either blank or hold dates

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Deb" wrote in message
...
Hi all - I have a column which can include a date (eg format 10 June 2009)
and I want to be able to count the total number of times a date appears in
that column. I also have another column which includes the letter 'y' in
some cells. I also wish to count the total number of 'y's. Can anyone
help.
As you can read I am so rubbish at that it is pitiful! Deb

Counting in columns
 

Use

=COUNT(A:A)

If this post helps click Yes
---------------
Jacob Skaria


"Deb" wrote:

Hi Jacob

The dates are all different. What I need to is to be able to know how many
cells have dates in.

"Jacob Skaria" wrote:

Hope the dates are formatted to excel date format. IF so

=COUNTIF(A:A,DATE(2009,6,10))
will give you the number of dates with 6th June 2009 in Column A

=COUNTIF(A:A,"Y")
will give you the number of Y's in Column A

--
If this post helps click Yes
---------------
Jacob Skaria


"Deb" wrote:

Hi all - I have a column which can include a date (eg format 10 June 2009)
and I want to be able to count the total number of times a date appears in
that column. I also have another column which includes the letter 'y' in
some cells. I also wish to count the total number of 'y's. Can anyone help.
As you can read I am so rubbish at that it is pitiful! Deb

Counting in columns
 

On 10 Iun, 15:36, Deb wrote:
*What I need to is to be able to know how many cells have dates in.

Maybe next (count and cells with text) :

=COUNTBLANK(A:A)
or : = 65536 - COUNTBLANK(A:A)