Hi
I have a column called year group, one called total attendance and one
called possible total. I would like to create the total % attendance for the
group year 7 by adding up the total attendances and making this a % of the
possible total:

e.g.

Year 7, 213, 290
Year 8, 214, 290
Year 7, 203, 270
Year 8, 213, 260

So I would like to add only those that relate to year 7, and then create a %.

Is this possible?