Assuming your data from H5:H10

H11: =SUM(H5:OFFSET(H11,-1,0))

Adjust to suit

"Mike" wrote:

I have a workbork that does a mdb query by Date Range. Different Date ranges
returns more or less data. I would like to have Column H to total up at end
of data. My Start of data is H5. Can someone give me some insight on how to
do this

Thanks Mike