Wow, what a quick response. I wish that solution was that simple, but the
problem with =SUM(F6:F30) is that the rows I want to sum change if a product
is added or removed from the worksheet. For example, now it may be
=SUM(F6:F30) once a product is added it may be =SUM(F6:F39) or =SUM(F6:F15)
if a product is removed.

"CLR" wrote:

Then just limit the Range of cells to those of interest, like

=SUM(F6:F30) for example

Vaya con Dios,
Chuck, CABGx3



"RyanH" wrote:

I appreciate the reponse, but there is an issue. I failed to mention that
this is a sub-Total cell. I will also have a tax cell, shipping cell, and
TOTAL cell below the sub total. So I am back to my orginal question.

"ShaneDevenshire" wrote:

Hi Ryan,

If there are no numbers in the cells F1:F5 then you can use:

=SUM(F:F)


--
Cheers,
Shane Devenshire


"RyanH" wrote:

I am using VBA to produce a quote worksheet with product descriptions in
column C and the product price in Column F. I want to sum from Cell F6 to
the last product price which varies as products are added and removed from
the worksheet. What formula can I put in the TOTAL cell to show the sum of
all the product prices?