Spreadsheet: 271189d1381858446-how-to-sum-cells-based-off-of-a-date-range-test-file-2
Sheet: Data Sheet

2013-01-01 00:00:00 | Total | 2013-02-01 00:00:00 | Total | 2013-03-01 00:00:00 | Total | 2013-04-01 00:00:00 | Total | 2013-05-01 00:00:00 | Total | 2013-06-01 00:00:00 | Total | 2013-07-01 00:00:00 | Total | 2013-08-01 00:00:00 | Total | 2013-09-01 00:00:00 | Total | 2013-10-01 00:00:00 | Total | 2013-11-01 00:00:00 | Total | 2013-12-01 00:00:00 | Total | End of Year Totals
Complete |  | Complete |  | Complete |  | Complete |  | Complete |  | Complete |  | Complete |  | Complete |  | Complete |  | Complete |  | Complete |  | Complete
AMA |  | AMA |  | AMA |  | AMA |  | AMA |  | AMA |  | AMA |  | AMA |  | AMA |  | AMA |  | AMA |  | AMA
Other |  | Other |  | Other |  | Other |  | Other |  | Other |  | Other |  | Other |  | Other |  | Other |  | Other |  | Other
Medical |  | Medical |  | Medical |  | Medical |  | Medical |  | Medical |  | Medical |  | Medical |  | Medical |  | Medical |  | Medical |  | Medical
Administrative |  | Administrative |  | Administrative |  | Administrative |  | Administrative |  | Administrative |  | Administrative |  | Administrative |  | Administrative |  | Administrative |  | Administrative |  | Administrative
Relapse |  | Relapse |  | Relapse |  | Relapse |  | Relapse |  | Relapse |  | Relapse |  | Relapse |  | Relapse |  | Relapse |  | Relapse |  | Relapse
Clinical |  | Clinical |  | Clinical |  | Clinical |  | Clinical |  | Clinical |  | Clinical |  | Clinical |  | Clinical |  | Clinical |  | Clinical |  | Clinical
[NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME]
Partial |  | Partial |  | Partial |  | Partial |  | Partial |  | Partial |  | Partial |  | Partial |  | Partial |  | Partial |  | Partial |  | Partial
January 2013 LOS | In Days | February 2013 LOS | In Days | March 2013 LOS | In Days | April 2013 LOS | In Days | May 2013 LOS | In Days | June 2013 LOS | In Days | July 2013 LOS | In Days | August 2013 LOS | In Days | September 2013 LOS | In Days | October 2013 LOS | In Days | November 2013 LOS | In Days | December 2013 LOS | In Days | End of Year Totals
Complete |  | Complete |  | Complete |  | Complete |  | Complete |  | Complete |  | Complete |  | Complete |  | Complete |  | Complete |  | Complete |  | Complete
AMA |  | AMA |  | AMA |  | AMA |  | AMA |  | AMA |  | AMA |  | AMA |  | AMA |  | AMA |  | AMA |  | AMA
Other |  | Other |  | Other |  | Other |  | Other |  | Other |  | Other |  | Other |  | Other |  | Other |  | Other |  | Other
Medical |  | Medical |  | Medical |  | Medical |  | Medical |  | Medical |  | Medical |  | Medical |  | Medical |  | Medical |  | Medical |  | Medical
Administrative |  | Administrative |  | Administrative |  | Administrative |  | Administrative |  | Administrative |  | Administrative |  | Administrative |  | Administrative |  | Administrative |  | Administrative |  | Administrative
Relapse |  | Relapse |  | Relapse |  | Relapse |  | Relapse |  | Relapse |  | Relapse |  | Relapse |  | Relapse |  | Relapse |  | Relapse |  | Relapse
Clinical |  | Clinical |  | Clinical |  | Clinical |  | Clinical |  | Clinical |  | Clinical |  | Clinical |  | Clinical |  | Clinical |  | Clinical |  | Clinical
[NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME]
Partial |  | Partial |  | Partial |  | Partial |  | Partial |  | Partial |  | Partial |  | Partial |  | Partial |  | Partial |  | Partial |  | Partial
Sample formula I used to count the total of each type of discharge:  =COUNTIF('January 2013'!L:L,A2)
I calculated the LOS for each type of discharge by using this formula ----> =IF(L3="Complete",P3,"") for each type of discharge on the respective month's sheet.
at the end of each month I would use a simple sum formula to add the total for each type of discharge for that month
and then I would special copy the sum to my data sheet in it's respective spot.  Unfortuntely not all clients discharge in the month they are admitted so it doesn’t work!