Prev: Hyperlink won't open in excel
Next: stock control template
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:CFCFD3C2-383C-4821-8B37-9E0D604D6BD7(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