LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Andy
 
Posts: n/a
Default Conditional Sum of Quarters

I have tried the conditional sum to calculate quartely results for the
following:

Measures Month Population Sample Population Missing/Invalid
Population Numerator Missing/Invalid Numerator Denominator Observed Rate
Discharge instructions JAN 2005 63 63 0 2 0 48 4%
Discharge instructions FEB 2005 69 69 0 7 0 48 15%
Discharge instructions MAR 2005 72 72 0 6 0 50 12%
LVF assessment JAN 2005 63 63 0 51 0 60 85%
LVF assessment FEB 2005 69 69 0 56 0 65 86%
LVF assessment MAR 2005 72 72 0 59 0 66 89%
ACEI or ARB for LVSD JAN 2005 63 63 0 16 0 24 67%
ACEI or ARB for LVSD FEB 2005 69 69 0 15 0 26 58%
ACEI or ARB for LVSD MAR 2005 72 72 0 25 0 37 68%
Adult smoking cessation advice/counseling JAN 2005 63 63 0 2 0 7 29%
Adult smoking cessation advice/counseling FEB 2005 69 69 0 2 0 5 40%
Adult smoking cessation advice/counseling MAR 2005 72 72 0 5 0 9 56%
Discharge instructions APR 2005 65 65 0 7 0 51 14%
Discharge instructions MAY 2005 62 62 0 13 0 46 28%
Discharge instructions JUN 2005 56 56 0 10 0 40 25%
LVF assessment APR 2005 65 65 0 58 0 62 94%
LVF assessment MAY 2005 62 62 0 53 0 57 93%
LVF assessment JUN 2005 56 56 0 44 0 50 88%
ACEI or ARB for LVSD APR 2005 65 65 0 19 0 35 54%
ACEI or ARB for LVSD MAY 2005 62 62 0 20 0 32 63%
ACEI or ARB for LVSD JUN 2005 56 56 0 18 0 28 64%
Adult smoking cessation advice/counseling APR 2005 65 65 0 2 0 7 29%
Adult smoking cessation advice/counseling MAY 2005 62 62 0 4 0 7 57%
Adult smoking cessation advice/counseling JUN 2005 56 56 0 3 0 6 50%


But I am unable to say I want Measures=Discharge Instructions, Month to
equal, Jan 2005, Feb 2005, Mar 2005.

Please help
--
Thanks,
Andy
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Keeping conditional formatting when sorting Andrea A Excel Discussion (Misc queries) 0 April 4th 06 03:00 PM
Conditional Formatting when inserting a row zahoulik Excel Worksheet Functions 2 January 7th 06 03:01 PM
Conditional Format Not Working KMH Excel Discussion (Misc queries) 0 December 22nd 05 05:32 PM
Conditional formula - language needed gamebird Excel Worksheet Functions 7 October 10th 05 11:48 PM
Conditional formatting not available in Excel BAB Excel Discussion (Misc queries) 2 January 1st 05 03:33 PM


All times are GMT +1. The time now is 09:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"