From: Eskercat on 13 Apr 2010 09:35 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?
From: Ashish Mathur on 13 Apr 2010 10:06 Hi, Try this =sumif($B$2:$B$5,D7,$C$2:$C$5)/sumif($B$2:$B$5,D7,$D$2:$D$5) D7 has Year 7. I have assumed that the data below is in range B2:D5  Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Eskercat" <Eskercat(a)discussions.microsoft.com> wrote in message news:CFCFD3C2383C48218B379E0D604D6BD7(a)microsoft.com... > 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?

Pages: 1 Prev: Hyperlink won't open in excel Next: stock control template 