I can't figure out how to go about writing a formula for this.

Here's a link to my sample editable spreadsheet in Onedrive:

https://1drv.ms/x/s!AjE7rOJOD5SS0A56EdcLfmKnJeMO

At the top is some sample data collected from students taking a pre and post fitness assessment. If they did both the pre and the post, they receive 25 points. If they did only one, they receive 0 points. I also need to get the average between the pre and post test.

Any help is much appreciated!

Thanks,

Tim