Hi all

I have found similar questions on this for Vlookups but not with Sumifs so here's my problem.
I have this formula and I need it to return blank not 0 , using other threads I added another level but to no avail - please help! :-)

Original:

=IF(ISERROR(SUMIFS(Data!$E:$E,Data!$C:$C,'Own Brand Data New'!AA$1,Data!$A:$A,'Own Brand Data New'!$B2)),"""",(SUMIFS(Data!$E:$E,Data!$C:$C,'Own Brand Data New'!AA$1,Data!$A:$A,'Own Brand Data New'!$B2)

Then tried:

=IF(ISERROR(SUMIFS(Data!$E:$E,Data!$C:$C,'Own Brand Data New'!AA$1,Data!$A:$A,'Own Brand Data New'!$B2)),"""",IF(SUMIFS(Data!$E:$E,Data!$C:$C,'Own Brand Data New'!AA$1,Data!$A:$A,'Own Brand Data New'!$B2)="""","""",SUMIFS(Data!$E:$E,Data!$C:$C,'Own Brand Data New'!AA$1,Data!$A:$A,'Own Brand Data New'!$B2)))