|OK, I made an error, but first I want to point out something about your SUM formula.|
These 2 formulas are equivalent:
This (your) formula is redundant, Excel is smart enough to ignore the fact that you are telling it to SUM the same numbers that you are manually SUMing.
In addition, if D2 and F2 are blank, then this formula will work just as well:
OK, as for my error, I posted too quickly and should have checked it more carefully.
or, if D2 & F2 are empty,
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.