Sum If Blank Cells

Silo

Active Member
Joined
Mar 8, 2004
Messages
447
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
 

Some videos you may like

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,105,968
Messages
5,508,465
Members
408,686
Latest member
celobacara

This Week's Hot Topics

Top