I've seen some similar topics to this; but I just can't seem to adapt

it. First I apologize for my novice-ness

I have a spreadsheet where the "data" portion can be variable (It is a

Pivot Table). That is why I find the Last Row because I then need to

add some lines directly under the Pivot Table.

I am having trouble trying to put those formulas into the spreadsheet.

First Formula is a simple SUM. =SUM(D175:D182). As you see below, I

just can't get it right.

Second Formula is an Array Formula -

{SUM(SUMIF($C$1:$C$175,data2,D1:D175))} but I didn't even come close on

this one.

My question is how to code the macro so that it puts the formula in the

spreadsheet.

Note: cLastRow = 175

"data2" is a range name in spreadsheet. It is the values that I am

summing.

Thanks.

Dim cLastRow, cLastcol

Sheets("Initial by Laser").Activate

cLastRow = Columns("A:A").Find(What:="Grand Total",

LookAt:=xlWhole).Row

Range("D" & cLastRow + 2).Formula = "=-d7"

Range("D" & cLastRow + 10).Formula = "=Sum(D & cLastRow & : & D &

cLastRow + 8)"

'Range("D" & cLastRow + 2).FormulaArray = {SUM(SUMIF("$C$1" & ":"&

"$C$"&clastrow,data1,"D1" & ":" & "D"&clastrow))}

'Range("D" & cLastRow + 2) = SUM(SUMIF($C$1:$C$175,data2,D1:D175))

## Bookmarks