Multiplication of multiple cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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...
 
Back
Top