I pull in an array of data and format it into a report.
Here's my problem:

In column H I need to insert the word "TOTAL" in the
second blank row below the last entry in the array.

In the same row, column J, I need to insert"=sum(j4:j
[whatever])" to sum the values in column J.

The number of rows can vary from 2 or 3 to several
thousand. Sometimes there are entries that take more than
one row for the data in the other columns, creatng empty
cells in H and J.

I've got everything else worked out except getting the
total in. Anyone have an idea or suggest a place to look?