Help in assigning formula to range

[Haree]

Hello, Kindly excuse me if this question is very elementary as I am new to VBA and am learning.

I have a defined range

dessum = wsd.Range("L2:L" & lastrowa)

I want to update the following formula in the entire range

=SUMIFS($F$2:$F$4,$C$2:$C$4,[@Names])-SUMIFS($E$2:$E$4,$C$2:$C$4,[@Names])

Any help would be greatly appreciated
Thank You

 

[RoryA]

You need Set when assigning a range to a variable, or you just get an array of values, so:

Set dessum = wsd.Range("L2:L" & lastrowa)
dessum.formula = "=SUMIFS($F$2:$F$4,$C$2:$C$4,[@Names])-SUMIFS($E$2:$E$4,$C$2:$C$4,[@Names])"

I'm assuming that the range is part of a table, based on your formula, in which case you should really refer to it as such.

 

[Haree]

@RoryA Thank you so much sir. It worked perfectly fine. Thanks for helping me out with set as well.
A small query, can I pull "lastrowa" inside my sumif formula. For Instance

=sumifs(("F2:F" & lastrowa),("C2:C" & lastrowa),[@Names])

If i can do how am i supposed to use the $ along with it
Thank you once again.

 

[RoryA]

You can but if your formula is in a table and referring to columns in that table, you might as well use table references.

 

[Haree]

Thank you so much sir. It saved a lot of time for me.