Need Worksheet Formula Corrected to use for VBA Macro

[dosbirn]

This formula works correctly in my spreadsheet but now I need to add it to a macro and this format will not work in VBA:

=SUMIFS($F:$F,$K:$K,"FC MNT",$M:$M,"")+SUMIF($K:$K,"FC MNT",$N:$N)

It sums the cells in column F, if column K contains the word "FC MNT" and if column M is blank; then it adds the sum of column N if column K contains "FC MNT.

I'm sure there is a better way to create the formula but this was the best way I could get it to work. Please let me know if you need more info.

Thanks,

Debbie

[JosephP]

are you trying to put that formula in a cell using vba or trying to replicate its function in code?

[dosbirn]

I'm trying to replicate it's function in code.

[dosbirn]

WAIT! I think I replied to quickly....give me a couple of minutes to think about it.

[dosbirn]

Okay - I'd like the code to insert the formula in cell L2. I was going to add "Range("L2").Formula = " to the front of the code, once someone replied.

[JosephP]

Please Login or Register  to view this content.

note the doubled-up quotes

[dosbirn]

AWESOME, JOSIE!

Thank you SO much for the quick response! I knew about the double-quotes (from examples of other formulas people here have helped me with) but I just couldn't figure out how to place all the data properly.

Thank you so much!

Debbie