help with formula

R

ronbwa

I have this data on sheet 1 in my work book


A B C D
1 DATE LIVES-D LIVES-S DROPS-D
2 1/1/08 1
3 1/2/08 9 3 0
4 1/3/08 7 1 6
5 1/4/08 5 1 7
6 1/5/08
7 1/6/08 2
8 1/7/08 10 4 4
9 1/8/08 10 1 3

On sheet 2 I have a created form by looking up data for any date selected(D6)
A B C D
6 DATE 3/3/08

DAYSHIFT SWINGSHIFT

LIVES 10 6

DROPS 11 4

FLOOR 66 72

SCR CS 26286 17176

SCR CS YTD 846885 809571

TOT CS 31496 20243

TOT CS YTD 1143204 1044965

% SCRS 83% 85%

% SCR YTD 74% 77%
********************************************************
AVG/DAY
LIVES YTD 440 3 4 215

DROPS YTD 350 2 8 410

FLOOR YTD 1883 12 41 2233

DAYS 54
********************************************************
Formula for lives(dayshift) is
=VLOOKUP(D6,Sheet1!A2:A367:Sheet1!B2:B367,2)........further down the form I
use the formula
=COUNTA(Sheet1!B2:B367) to count the number of entries in COLUMN B

On the form the entry in D6 is variable(date). I get everything to work
properly ex-cept for the days IN CLOUMN B TO CHANGE WITH RESPECT TO THE DATE
SELECTED. aNY HELP WILL BE GREATLY APPRECIATED.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top