Maintain values in a =sumif( formula

[msjohnson624]

I am trying to keep my sumif formula values from changing. I have macros set up to input different numbers or rows into a spreadsheet and a =sumif formula to find a value and add them together. THe probme i'm having is that my current formula (=SUMIF($C$1:$C$100,"value",$K$1:$K$100)) keeps changing when I use a macro. How do I keep this values static regardless of what data is input on the spreadsheet?

 

[Andrew Poulsom]

Welcome to MrExcel.

You could copy it and Paste Special|Values. Or you could set Calculation to manual.

 

[msjohnson624]

Thanks! I ended up just building the formulas into my macros so they will reset to the original ranges.