I'm using this code to add the words "Total" and "Items" in column A at the
end of a report I download each day with variable number of rows each day.
In column B I have the dollar amount on the same row as Total and the count
of rows next to Items. I need to add code to the below to convert these four
cells (which I can not identifiy the location of since the report varies each
day) to bold and the count number in column B needs to be text, it is
currently coming in as currency since that is how the column is formatted.
Your help is appreciated, thank you

Set rng = Cells(Rows.Count, 2).End(xlUp)

rng.Offset(2, -1).Value = "Total"
rng.Offset(3, -1).Value = "Items"

rng.Offset(2, 0).Value = Application.Sum(Range("B1", rng))
rng.Offset(3, 0).Value = Application.Count(Range("B1", rng))

Columns("A:I").Select
Columns("A:I").EntireColumn.AutoFit