Sum If Blank Cells

[Silo]

Hello everyone

I have a this for in C47 “=SUMIF('SUG''s Confirmed'!D:E,B47,'SUG''s Confirmed'!E:E)”

Problem is, B47 has a formula that brings in the value in from another cell on the sheet (=B23) So if B47 is blank because B23 is blank C47 will bring in values that are in cell the sum range that have values Range 'SUG''s Confirmed'!D:E

I need it to disregard these values

Any help would be appreciated

Thanks