Matthew,
Classical homework, isnt it? Its an example for using Excel function SUMIF
(find out the Help for this function). Make somewhere the column list of you
Wards. Next to the first Ward insert the function SUMIF. As its Range
argument select the range of your Wards from the patients list, as Criteria
select the link to the cell with Ward name, as Sum all of yours 1s and
nothings or zeros. The ranges should be anchored properly ($s). Copy the
SUMIF down for all Ward names. You will obtain the correct count in each
category. For graphical representation create bar chart.
For negative counting you have to know the totals of patients in Wards. You
obtain them by means of COUNTIF function. So, for each Ward from your list
insert this function to the next column with quite the same range and
criteria arguments as with SUMIF. The count of the not-meetings is mere a
difference.
Do the same with Hospitals.

--
Petr Bezucha


"matthewluck1" wrote:

Hi, I would be extremely grateful for some help with my spreadsheet.

I have the following data which I need to use to produce charts for a
hospital report fairly urgently.

The rows are the names of patients. This could be up to 200 for each month,
but this varies from month to month. I will have each month on a different
worksheet.

Column F - Ward
Column G - Hospital
Column K - I have a number 1 in the row if the patient meets the criteria

I need to produce a chart(s) to show and compare the following:

How many patients from each ward met the criteria (as indicated by 1 in
column K) and how many did not.

How many patients from each hospital met the criteria and how many did not.

I would really like some help!!!