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 stude...
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!