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?