Hi,
In Excel 2007 I need some help off the community to create a formula for my sheet.
Basically, for my dissertation I've conducted an online questionnaire and have my data stored in an excel spreadsheet. One question asks which campus at my university they are based at (A,B,C and OTHER) whilst the second asks them to rate an aspect on a scale of 1-10.
I want to create a formula to calculate the average score people give on the scale who are from campus A, then the same for campus B and so on.
I already have the total number of people at campus a on another sheet (Q2) in the workbook which I can use to divide it to give the average as shown below
What I'm asking is something like:
=SUM(IF(C2:C1000="A", THEN(I2:I1000=?)/Q2!B3
If you can help it would be much appreciated?
Bookmarks