Sum of Column
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 |
Sum of Column
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 |
All times are GMT +1. The time now is 04:46 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com