ISBLANK and SUMIF formula help - registering cells as not blank

[Karinanzr]

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",'Cleaned Data'!E:E,"Cedtara",'Cleaned Data'!H:H,"<>"),"$0.00")

Column H is the one that seems to be the problem. In Column H I have this formula: =IF(ISBLANK('Raw Data'!L34),"",'Raw Data'!L34)

So in this workbook I'm using formulas to calculate tips for certain appointment types. In column H in the raw data tab I'm using an ISBLANK formula to copy cell information from the previous tab, and leave it blank if there is nothing there. Because the formulas in the pay rate sheets (currently looking at Cedtara but this problem will be on everyone's sheet if I don't fix it) depend on checking whether a cell is blank or not. You can see in the first screenshot, an ISBLANK formula returns as FALSE for both of the blank cells (Cells H305/306 are referencing H34 and H112 to test it, the formula in the bar is the formula in the H34/H112 cells and H column as a whole). 

In the next screenshot, you can see the tip is being calculated in the unintended place. My formula is supposed to be asking it to sum up all of the tips (column F) with a 75 minute massage type (column D), with the name Cedtara in column E, and where column H is not blank. 

Does anyone know why this is and how to fix it? I'm scared that all of the formulas in this section are impacted if the problem is the isblank formula. 

I've deleted all sensitive data from the test workbook attached. Thank you for any help in advance!

[#2]

@Karinanzr 

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

[#3]

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

[#4]

@Karinanzr 

Excel keeps on running out of resources, so I'm afraid I cannot do anything with the workbook, sorry.