You have the formula in the same row or Column that you are totalling. Change the range to avoid the cell your formula is in e,g

assume formula in B2 then enter something like

=Sum(B3:B6000)

VBA Noob