Hi dmad81,


You can use the below formula:-

{=SUM(IF($D$3:$D$13>=($D$2*0.0004),D3:D13,""))}

See the attachment:-
SumIf issue.xlsx
regards,
DILIPandey

<click on below 'star' if this helps>