How do I calculate this church dinner list?

  • Thread starter Thread starter EmilyFlowers383
  • Start date Start date
E

EmilyFlowers383

I have a church supper list that charges $7/adult and $3.50/child.
Everytime I want to calculate that, I have to go under the total
column and write the function for each individual cell in the total
column. The function looks like =B4*7+C4*3.50, and so on based on
whichever cell it's in. Is there an easier way to do this so I don't
have to individually enter all the information into each cell of the
total column? Just wondering. Any help would be greatly appreciated.
Thanks,
Emily
 
presuming that "D" is the "total" column, copy the contents of the D4
cell to the rest of the D column.
 
One way

=SUMPRODUCT($B$4:$B$500*7+$C$4:$C$500*3.5)

will be the same as if you do

B4*7+C4*3.5+B5*7+C5*3.5 and so on

change the cell ranges to fit your requirements


--


Regards,


Peo Sjoblom
 
I have a church supper list that charges $7/adult and $3.50/child.
Everytime I want to calculate that, I have to go under the total
column and write the function for each individual cell in the total
column. The function looks like =B4*7+C4*3.50, and so on based on
whichever cell it's in. Is there an easier way to do this so I don't
have to individually enter all the information into each cell of the
total column? Just wondering. Any help would be greatly appreciated.
Click to expand...

Assuming you are placing your formulas in column D, click on D4 (which
should have the formula you posted above in it). Do you see that small,
black square in the bottom right corner of the selection border? Left-click
on it (you will know you are on it because the cursor will become a small
black plus sign) and drag down to the last row you think you will need to
put data in and then release the mouse button. What this does is copy the
formula from D4 into each cell, but it automatically adjusts the row
references (because you dragged down; if you dragged across, the columns
would have been adjusted instead). So, if you click in D5, you will see this
formula there...

=B5*7+C5*3.50

and if you click in D6, you will see this formula...

=B6*7+C6*3.50

and so on throughout the range you dragged that little black square in.

Rick
 
Back
Top