Non-General Conditional Sum VBA CODE

The calculation corresponds to C3:C26, and the sum of the amount of D3:D26 is placed in column E`

Can someone please help me ? It would be much appreciated

Hello. And if you want a way that doesn't contain iterations, you can try:

PHP Code: 

Sub Macro_8()
With Range("D3", [D3].End(xlDown))
  .Columns(2) = "=D3+E4-E4*(C4<>"""")"
  .Columns(2) = .Columns(2).Value
  .Columns(0).SpecialCells(4).Offset(, 2).ClearContents
End With
End Sub