Results don't macth.

[Lerner]

I got an application where I register admissions and discharge for a small
clinic I work
This application is set up to print a census at midnight every night. So far
this is
not problem, is reliable with tru numbers. After having some printer
problems and
loosing some midnight census I did a excel worsheet where every admission and
discharge is register with dates.
A B C
NAME ADM. DATE DISC. DATE

1

2

Column D =COUNTIF(B1:B2170,"1/01/2009") and copy down changing the date in
order to count how many admissions each date ( "1/02/2009", "1/03/2009",etc.)
Column E =COUNTIF(C1:C2170,"1/01/2009") and copy down... to know how many
discharges each day.
F will be the column that does not macth with the midnight census.
F= the previous day census+admissions-discharges.
Let's say F1=28
F2=F1+D2
Will give me the counting of admissions and
discharges(actual census) for 1/1/2009
F3=F2+D3-E3
Will give me the counting admissions and discharges(actual census) for
1/2/2009
Problem:
Column F does not macth the midnight print out previoussly done and is not
reliable for future calculations.
Is this a reference error, Xl error or Data error?
Differences are by 1 or 2 between midnight census and Column F in XL.
Thanks for your expertise.

 

[davemcochrane]

Hi, I am not sure of your layout, check out this example

http://sites.google.com/site/davesexcel/Home/forum-examples/AdminDiscConsensus.xls?attredirects=0

 

[Lerner]

Good replica. Almost the same.
Your SUMMARY sheet, column D
will be my equivalent to column F.
The formula is the same but using columns F,D and E.
The daily midnight print is the real, accurate one,
The XL worksheet should macth it.
Thanks.