Hi Todd,
your macro works fine for me if I only remove the space after Range("t9").
Like this I mean: Range("t9").Select

This gives the following formula result, when running the macro:
=SUMIF(G10:G45,">0",F10:F45)+SUM(N10:N45)+SUMMA(O1 0:O45)
which seems to be correct.

/Bjorn