Forum Discussion
ISBLANK and SUMIF formula help - registering cells as not blank
I'm having a problem where my =SUMIF formula is not registering that a cell is blank. This is the formula: =IFERROR(SUMIFS('Cleaned Data'!F:F,'Cleaned Data'!D:D,"75 Minute All-Inclusive Massage",'C...
As you have found, Excel treats a cell that contains a formula that returns "" as not-blank.
Try this formula:
=IFERROR(SUMIFS('Cleaned Data'!F:F,'Cleaned Data'!D:D,"75 Minute All-Inclusive Massage",'Cleaned Data'!E:E,"Cedtara",'Cleaned Data'!H:H,"> "),"$0.00")
Thank you for your response! It looks like with that formula the $32 does go away from the highlighted place which is correct, however it also gets rid of the 24.25 and 29.10 it's sandwiched between in cells H16/18 which is not correct. Do you know why that is? What is this formula saying compared to the one I have?
Alternatively...if there's a better way to accomplish the same results i can definitely change the formulas completely. I just can't think of any
Alternatively...if there's a better way to accomplish the same results i can definitely change the formulas completely. I just can't think of any
Excel keeps on running out of resources, so I'm afraid I cannot do anything with the workbook, sorry.