'm trying to program an invoice for a friend of mine and i have hit a doozy of a problem. The invoice is for a meat wholesale company and it has to display the catch weights next to the item, as well as calculate the total weight. Took me 2 seconds to write that up but here is the issue. In order to calculate the final weight for the line item, i was entering the SUM formula in total weight and just clicking and dragging the box over all the cells that would have weights entered. (i did that for the entire alloted area for catch weights, since each invoice will look a little different and i dont want to change the area each time) Now i have more than one item on the invoice, each with its own set of weights, and the SUM formula just adds ALL the weights for ALL the items, which is no good because each item has a different price per pound. Id rather not tell my friend to select the specific cells every time so only the total weight per line item was added. Does anyone know a way to terminate the SUM function if it came to a particular value or text in a cell? I basically need excel to sum the weights in the cells before a termination value/text/formula and after that particular cell it would stop adding anything that came after it. (meaning in the next cell or anything below) I'm thinking maybe an IF/THEN formula could do it but i just wanted to see if anyone had a different approach. Any help greatly appreciated, looking back im sure the solution is rather simple but i never came across a problem like this one before.