=SUM(F6:F65000)

Vaya con Dios,
Chuck, CABGx3



"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?