From: hotrodflatglass on 17 Mar 2010 14:22 Russel N15 will have the total depending the number I put in N8 column -- Thanks Mike "Russell Dawson" wrote: > What you appear to be doing can be a very simple calculation of > =L8*N8+L9*N9+L10*N10 (in your given figures) but that is not a satisfactory > way to handle this problem. > You should be using a column which calculates the total value of each row > and then calculate the total at the bottom of the row. > So you would introduce a column P for instance - in P8 input =l8*n8 > Copy that down to the extent of your range and in P15 input =sum(P8:P14) > This allows you to extend the range downwards without ever having to rethink > your calculations. > -- > Russell Dawson > Excel Student > > Please hit "Yes" if this post was helpful. > > > "hotrodflatglass" wrote: > > > L8 through L14 has \$amount, N8 through N14 has # of pieces. I need N15 to > > have the total \$amount. > > Example > > > > L8 N8 > > 23.00 2 > > 14.00 0 > > 5.00 1 > > > > N!4 > > 51.00 > > I have searched and found a few examples but had a lot more involvement > > Thanks > > > > > > > > Thanks > > Mike  |  Pages: 1 Prev: how to write valueNext: Help with Ribbons! AAARGH!