Conting none blank fields

[Ian T]

I have a table that holds employee data, working days &
roster off days.

The top row Starts at say C4 (with date 20/09/2004) & has
every day of the year along the worksheet, (C4 - C369.)

At any time in the year I will place a 1 in a cell when a
person is off or absent say F5, G5, H7 under cell F4, G4,
H4 = 1

What I want to do is lookup today's date i.e. =now () in
the top row & count the number of cells that contain data
i.e. a 1 in the bottom row up to the end cell bellow
C369.
For instance based on the above data 3 would be returned
if today's date is 20/09/04 & 2 if today's date is
24/09/04.

I can find the cell reference & index to the today field
but can't count the any empty fields.
Any one help pleeeeeeaase ????

 

[Frank Kabel]

i
not really sure what is in a column in your file and what
is in a row. Please post some example rows of data

 

[Guest]

C D E F G H I J
K L M N
20/09/2004 21/09/2004 22/09/2004 23/09/2004
24/09/2004 25/09/2004 26/09/2004
27/09/2004 28/09/2004 29/09/2004
30/09/2004 01/10/2004
1 1 1 1 1 1 1
1
Need to count the days off in row 5 from the current date
hope this helps?

 

[Frank Kabel]

Hi
if the dates are in row 4 try:
=SUMPRODUCT(--(4:4>=TODAY()),--(5:5=1))

 

[Ian T]

Hey Frank coo that works fine.
Just one more ?
If the all but 2 of the 1's were all changed to 7's & the
last two changed to 9's how would I add them all together
to get 60, and as the days go by this figure updates?

 

[Frank Kabel]

Hi
do you mean:
=SUMPRODUCT(--(4:4>=TODAY()),--(5:5<>""),5:5)

 

[Ian TRan]

Cool Thats the one Your the Dude!!!!!!!!!
Thanx.

-----Original Message-----
Hi
do you mean:
=SUMPRODUCT(--(4:4>=TODAY()),--(5:5<>""),5:5)

--
Regards
Frank Kabel
Frankfurt, Germany



.