Re: Counting Cells

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: "Roger Govier" <roger@xxxxxxxxxxxxxxxxxxxxxxxx>
Date: Tue, 2 Aug 2005 18:26:00 +0100

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

--
Regards

Roger Govier

"Don" <Don@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:830911F4-B063-4DDE-9FE8-EC0D6DFBFDF2@xxxxxxxxxxxxxxxx
>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

.

References:
- Counting Cells
  - From: Don

Prev by Date: Re: subtracting based on available values
Next by Date: RE: Negative %
Previous by thread: Re: Counting Cells
Next by thread: How do i get the running balance from one work*** to another?
Index(es):
- Date
- Thread