Multiplication of multiple cells

[Littlecharmer]

I am trying to put my school dinner register on excel.

I need to be able to work out how much money is due by adding the number of
meals ordered (involving more than one cell) and then multiplying that number
by the cost of the meal e.g. £1.60

How can I do this?

 

[Guest]

how about

=sum(a1...a17)*1.60

where a1 through a17 represents the number of dinners and 1.60 is the price
you are mentioning...

 

[Littlecharmer]

Thanks very much! I just worked this function in and it works!