Counting Frequency of Number of Visits from Detailed Data

[shellp]

Hello

I am using Excel 2010. I have my raw data worksheet with every single ED visit where one visit is one row of data. In column I of the raw data I have a column of MH for mental health which is a 0 or 1 for if the patient was a mental health patient or not. I would like to determine the number of days in each month where there were more than 2 mental health patients in a single day.

I can create a pivot table, group on registration date and sum the mental health visits but how do I translate that information to a chart on another worksheet? Using sumif I can calculate the number of mental health ED visits per month but in the same table I want to have the metric of "number of days where there were more than 2 MH patients in a single day" and can't figure out how to do it.

Any and all assistance greatly appreciated.

 

[mrshl9898]

Since you're familiar with SUMIF

Use COUNTIFS(date column, date, MH column, 1) to add number of MH per day to a new column.

Then add that as a filter to your pivot.