T
Tasha
I got this to work in another workbook, but won't work in this one....can
someone help me figure out what is wrong?
A little Background first:
workbook: September MTD Stats.xls
worksheet: cnsdlywrksht Defined Names:CNSDAY, HSV, F/C
worksheet: PATIENT_DAYS
layout of cnsdlywrksht:
A B C D E F G
RM PATNO PATIENT NAME CNSDAY STAY F/C HSV
161 178 xxxxxJANE DOE 1 11 V IPS
162 135 xxxx BRENDA 5 8 D IPM
OB2 138 xxxx PAT 1 2 S IPO
163 137 xxxxxxJOHN 5 5 D IPM
*CNSDAY is date 09/01/07 formatted as day, displays as 1
layout of PATIENT_DAYS:
A B C D E F G H I J
PAT DAYS 1 2 3 4 5 6 7 8 9 etc... <---(date form as day)
(row 3 is blank)
IPM 2
IPO 1
IPS 1
etc...
layout above is hard to show, but under patient day 1(09/01/07) column, in
cell next to IPM, I want it to give me the total number of patients from the
worksheet cnsdlywkrsht that have a census date of 09/01/07 and a HSV code of
IPM. I use this on another workbook and it works fine, but keep getting #N/A
error on this one for some reason.
The defined names are set up as follows:
CNSDAY - =OFFSET(cnsdlywrksht!$D$2,0,0,COUNTA(cnsdlywrksht!$D:$D),1)
HSV - =OFFSET(cnsdlywrksht!$G$2,0,0,COUNTA(cnsdlywrksht!$G:$G),1)
F/C - =OFFSET(cnsdlywrksht!$F$2,0,0,COUNTA(cnsdlywrksht!$F:$F),1)
Sorry this was so long, Please help????? Thanks so much!
someone help me figure out what is wrong?
A little Background first:
workbook: September MTD Stats.xls
worksheet: cnsdlywrksht Defined Names:CNSDAY, HSV, F/C
worksheet: PATIENT_DAYS
layout of cnsdlywrksht:
A B C D E F G
RM PATNO PATIENT NAME CNSDAY STAY F/C HSV
161 178 xxxxxJANE DOE 1 11 V IPS
162 135 xxxx BRENDA 5 8 D IPM
OB2 138 xxxx PAT 1 2 S IPO
163 137 xxxxxxJOHN 5 5 D IPM
*CNSDAY is date 09/01/07 formatted as day, displays as 1
layout of PATIENT_DAYS:
A B C D E F G H I J
PAT DAYS 1 2 3 4 5 6 7 8 9 etc... <---(date form as day)
(row 3 is blank)
IPM 2
IPO 1
IPS 1
etc...
layout above is hard to show, but under patient day 1(09/01/07) column, in
cell next to IPM, I want it to give me the total number of patients from the
worksheet cnsdlywkrsht that have a census date of 09/01/07 and a HSV code of
IPM. I use this on another workbook and it works fine, but keep getting #N/A
error on this one for some reason.
The defined names are set up as follows:
CNSDAY - =OFFSET(cnsdlywrksht!$D$2,0,0,COUNTA(cnsdlywrksht!$D:$D),1)
HSV - =OFFSET(cnsdlywrksht!$G$2,0,0,COUNTA(cnsdlywrksht!$G:$G),1)
F/C - =OFFSET(cnsdlywrksht!$F$2,0,0,COUNTA(cnsdlywrksht!$F:$F),1)
Sorry this was so long, Please help????? Thanks so much!