L
Linda RQ
Hi Everyone,
I am using Excel 2003. I understand there is probably a very sophisticated
way to get what I want but I need to learn the simple way first. I have a
data sheet named "MICU". I inserted another sheet in the workbook called
"Stats". I want to break down the data by month on my new Stats sheet. The
MICU sheet has many columns of info. The 2 I think I need to use is a
column for start date "ThpyStDtTm" (Date and Time field 3/14/09 18:41) and
a column called "VentLOSDays" (Number format with 2 decimal places).
Column A Column B
Month Ave VentLOS
June-08 2.41
July-08 3.75
Aug-08 3.42
I clicked on cell B2 (The June-08 Ave VentLOS cell) and inserted the ave
function using the Insert/Function tool menu then used the little function
arguments dialog box to go to the MICU sheet and selected all the numbers in
the average LOS column for patients started on therapy in June. Is there a
way to have an argument in there to find all the records from June 08 using
the ThpyStDtTm column? This is what my function looks like so far =AVERAGE
('MICU'!K17:K52). The July-08 looks like this =AVERAGE ('MICU'!K53:K93).
This works great but I have to select by hand/eye which is time consuming
and errors occur if "I haven't had enough coffee" and I am not sure what
will happen if I decide to exclude a record later on, or perhaps sort this
list another way.
Thanks,
Linda
I am using Excel 2003. I understand there is probably a very sophisticated
way to get what I want but I need to learn the simple way first. I have a
data sheet named "MICU". I inserted another sheet in the workbook called
"Stats". I want to break down the data by month on my new Stats sheet. The
MICU sheet has many columns of info. The 2 I think I need to use is a
column for start date "ThpyStDtTm" (Date and Time field 3/14/09 18:41) and
a column called "VentLOSDays" (Number format with 2 decimal places).
Column A Column B
Month Ave VentLOS
June-08 2.41
July-08 3.75
Aug-08 3.42
I clicked on cell B2 (The June-08 Ave VentLOS cell) and inserted the ave
function using the Insert/Function tool menu then used the little function
arguments dialog box to go to the MICU sheet and selected all the numbers in
the average LOS column for patients started on therapy in June. Is there a
way to have an argument in there to find all the records from June 08 using
the ThpyStDtTm column? This is what my function looks like so far =AVERAGE
('MICU'!K17:K52). The July-08 looks like this =AVERAGE ('MICU'!K53:K93).
This works great but I have to select by hand/eye which is time consuming
and errors occur if "I haven't had enough coffee" and I am not sure what
will happen if I decide to exclude a record later on, or perhaps sort this
list another way.
Thanks,
Linda