Forum Discussion
Can this be done...and if so how?
I have a spread sheet for my classroom of students. The students take tests and the information is brought in automatically. I am trying to figure out if I can write a function where if the students name is the same in column A (for example A1 Billy Bob A 2 Billy Bob A3 Billy Bob A4 Joe Bob A5 Joe Bob A6 Joe Bob). I need it to recognize the names that are the equal and then add other colums (like B1,B2B3, C1, C2, C3, D1, D2, D3) and give me an average output in E3. and then do the next student. I am guessing it would be an if then function, but not sure how to make it work.
3 Replies
- can you perhaps post some sample (made-up) data? I am guessing you would be helped keeping your data plain and simple (no calculations) and then using a pivot table to summarize the data.
Okay I created an example of data. I want to be able to have an output that adds up all of the data and provides an average only in the one spot..you will see there are multiple names that are all the same and I want to add up their results and output an average where the ??? mark appears. The problem is the amount of names will not always be consistent. Sometimes it might be 2 and sometimes 6. Also, the amounts of data across may or may not be consistent. Not sure how to make that happen. Any help is appreciated.
Thanks,
Marshall
- Easy enough.
- remove the average calculation at the bottom
- Format data as a table (Home tab, format as table)
- Press insert, Pivot table
- check all the fields
- right-click the number columns and choose "Summarize Values by", "Average". Repeat for each value field.
- Done!
