View Single Post
  #5   Report Post  
Gordon
 
Posts: n/a
Default

<goseespam@lot wrote in message
...
But, Anne,

If you have a large list of these materials and costs, how do you put
in the formula - quickly - for each calculation? If I understand you,
you have to manually change the formula for each row and enter it into
Col D. For example: C2*B2, then C3*B3, then C4*B4, etc, etc.


Just enter the formula in the first row then either drag or fill down. The
formula will change automatically to reflect the row it is on.