Making the criteria in a SUMIF function relative to the active cell

[kays23]

=SUMIF($C:$C,$C$4,D:D)

The criteria in this formula always needs to reference the cell "ActiveCell.Offset(-1, -1)". Is there a way to do this through VBA?

SUMIF(C3,R4C3,C) This is what is looks like on VBA.


Thanks

 

[DanteAmor]

Welcome to the forum!

Hi @★ kays23 , I don't understand the formula, it seems that the formula is in the same column D. That is a circular reference error.
You could explain how you have the data and what you expect from the result.

 

[kays23]

Welcome to the forum!

Hi @★ kays23 , I don't understand the formula, it seems that the formula is in the same column D. That is a circular reference error.
You could explain how you have the data and what you expect from the result.

I expect the macro to be able to input the sumif formula referencing the range as column $C, the criteria as $ActiveCell.Offset$(-1,-1) and the sum range as the column of the active cell so D but not locked as the sum range will change.
Hope this makes sense, When I enter this formula it returns the correct amount and does not produce an error

 

[DanteAmor]

Just to understand, you could give an example of how your data is and where you want to put the formula.