Insert Title for sum of single column in Excel
Posted on 2014-04-01
What code can I use to include a name title, such as Total, for the sum of the single column(extralinens)? I want the total to appear on the same Row as the sum of extralinens.
LOCAL lnTotalCellRow, lnTotalCellCol, lnRecords
lnRecords = Reccount("queryovrblkt")
lnTotalCellCol = 3 && "C"
lnTotalCellRow = lnRecords +3
* adding 3:
*+1 for captions row,
*+1 for the additional row inserted for the Date,
*+1 to use the row beneath all records