New to Excel please help

[Stphn]

Although I have used different versions of the office product I have never used excel.

I am designing an excel document which when completed will allow me to keep an uptodate record of what the cadets do throughout the calendar year. The document comprises of five worksheets on of records monthly attendances.

The initial eight or nine columns, depending on the month record attendance. This is collated in the column immediately following the last date entry using the following formula (=SUM(F6,G6,H6,I6,J6,K6,L6,M6,N6)).

The next column records their score from the monthly inspection, the last column is the total score for each cadet for the month again using =SUM formula.

I am unsure how do the other two columns one is called Extra the other as yet is untitled. What I would like the formula to do is this. The 'Extra' column is where I want to record the number of extra activities the cadet undertakes with the score appearing in the as yet untitled column, so if they attend 5 extra activities the untitled column would show a score of 75. This is where my problem is I have idea what formula to use.

Under the additional options I have uploaded a picture of what I am trying explain any help would be appreciated.

Stephe