Counting Cells

=COUNTA(INDIRECT("A1:A"&DAY(TODAY())))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Don" <[email protected]> wrote in message
news:[email protected]...
> I have a column of numbers, 1-31. Each number is the number of a day of
the
> month. Some days are missing and a blank has been left for those days (in
> the column).
> Can someone help me with this problem? I want to return the count for the
> days that are listed (omitting the blanks) but I only want to count the
days
> that are less than or equal to =day(today()). Can someone show me how to
> write this? It's driving me mad. Thanks for any help.
> --
> Don Rountree

=SUMPRODUCT(--(A1:A31<>""),--(A1:A31<DAY(TODAY())))

--
Regards

Roger Govier


"Don" <[email protected]> wrote in message
news:[email protected]...
>I have a column of numbers, 1-31. Each number is the number of a day of
>the
> month. Some days are missing and a blank has been left for those days (in
> the column).
> Can someone help me with this problem? I want to return the count for the
> days that are listed (omitting the blanks) but I only want to count the
> days
> that are less than or equal to =day(today()). Can someone show me how to
> write this? It's driving me mad. Thanks for any help.
> --
> Don Rountree

=COUNTA(INDIRECT("A1:A"&DAY(TODAY())))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Don" <[email protected]> wrote in message
news:[email protected]...
> I have a column of numbers, 1-31. Each number is the number of a day of
the
> month. Some days are missing and a blank has been left for those days (in
> the column).
> Can someone help me with this problem? I want to return the count for the
> days that are listed (omitting the blanks) but I only want to count the
days
> that are less than or equal to =day(today()). Can someone show me how to
> write this? It's driving me mad. Thanks for any help.
> --
> Don Rountree

=SUMPRODUCT(--(A1:A31<>""),--(A1:A31<DAY(TODAY())))

--
Regards

Roger Govier


"Don" <[email protected]> wrote in message
news:[email protected]...
>I have a column of numbers, 1-31. Each number is the number of a day of
>the
> month. Some days are missing and a blank has been left for those days (in
> the column).
> Can someone help me with this problem? I want to return the count for the
> days that are listed (omitting the blanks) but I only want to count the
> days
> that are less than or equal to =day(today()). Can someone show me how to
> write this? It's driving me mad. Thanks for any help.
> --
> Don Rountree

I have a column of numbers, 1-31. Each number is the number of a day of the
month. Some days are missing and a blank has been left for those days (in
the column).
Can someone help me with this problem? I want to return the count for the
days that are listed (omitting the blanks) but I only want to count the days
that are less than or equal to =day(today()). Can someone show me how to
write this? It's driving me mad. Thanks for any help.
--
Don Rountree

=COUNTA(INDIRECT("A1:A"&DAY(TODAY())))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Don" <[email protected]> wrote in message
news:[email protected]...
> I have a column of numbers, 1-31. Each number is the number of a day of
the
> month. Some days are missing and a blank has been left for those days (in
> the column).
> Can someone help me with this problem? I want to return the count for the
> days that are listed (omitting the blanks) but I only want to count the
days
> that are less than or equal to =day(today()). Can someone show me how to
> write this? It's driving me mad. Thanks for any help.
> --
> Don Rountree

=SUMPRODUCT(--(A1:A31<>""),--(A1:A31<DAY(TODAY())))

--
Regards

Roger Govier


"Don" <[email protected]> wrote in message
news:[email protected]...
>I have a column of numbers, 1-31. Each number is the number of a day of
>the
> month. Some days are missing and a blank has been left for those days (in
> the column).
> Can someone help me with this problem? I want to return the count for the
> days that are listed (omitting the blanks) but I only want to count the
> days
> that are less than or equal to =day(today()). Can someone show me how to
> write this? It's driving me mad. Thanks for any help.
> --
> Don Rountree