Multiplication of multiple cells

L

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?
 
G

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to implement two shifts per day with multiple teams 0
Simple Copy to and From Cells With IF statement. 3
How can the font and size of (all) citation numbers be altered? 1
how to copy all attachments from multiple emails to a new email in Outlook 0
accumulating multiple material costs for a task 6
accumulating multiple material costs for a task 3
Forms & Queries 0
Sorting Changes Cell References 0

Top