Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
counting in columns | Excel Worksheet Functions | |||
counting in columns | Excel Worksheet Functions | |||
Counting in Columns | Excel Worksheet Functions | |||
Counting in two columns | Excel Worksheet Functions | |||
counting columns | Excel Worksheet Functions |