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
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