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