Hi, I wonder whether someone may be able to help me please.

The script below initially checks to see if there are any values in column B of a given page. If there are it applies a 'Sum' formula and creates a 'Totals' row on the next available row starting one column to the left.

Sub InsertTotals()
Dim colm As Long, StartRow As Long
Dim EndCell As Range
Dim ws As Worksheet
StartRow = 5
For Each ws In Worksheets(Array("Direct Activities", "Enhancements", "Indirect Activities", "Overheads"))
    Set EndCell = ws.Cells(Rows.Count, "B").End(xlUp).Offset(1, 1)
    If EndCell.Row > StartRow Then EndCell.Resize(, 12).Formula = "=SUM(R" & StartRow & "C:R[-1]C)/7.4"
    EndCell.HorizontalAlignment = xlCenter
    ws.Columns("B:N").EntireColumn.AutoFit
    
Next ws
End Sub
I'd now like to add a second formula row, which will appear under the 'Totals' row, but only if it has been created. The formula I'd like to add is:

•Use the figure in the 'Totals' row multiplied by the figure in row 3 of the relevant column.

But I'm really not sure how to go about this.

I just wondered whether someone may be able to look at this please and offer some guidance on how I may go about achieving this.

Many thanks and kind regards