Formula

Hi Sarah

Don't worry we all have mental blocks at times, thankfully, that's why we have the forum to help :)

A B C D
1 Name: No Of Visits Cost per visit Total Cost
2 John Smith 12 £530 =B2*C2
3 Sara C-G 10 £530 =B3*C3

The above example allows a different No of Visits and Cost per vist

If you want one cost to apply for all you can refer to an individual cell using an Absolute cell reference ($)

A B C
1 Cost per Visit £530
2
3 Name: No Of Visits Total Cost
4 John Smith 12 =$B$1*B4
5 Sara C-G 10 =$B$1*B5


Hope this makes sense and answers your question.

Regards
Dennis