Using Sumifs where one of the criteria might be blank.

[RockandGrohl]

Hi all, I have the following sumif, and the part I've bolded I will explain below.

=SUMIFS(Data!$F:$F,Data!$V:$V,$B2,Data!$R:$R,$D2,[B]Data!$S:$S,$E2[/B],Data!$T:$T,$I2,Data!$U:$U,$J2)

So the S:S column can either be blank, or have results in it like "Apple", "Banana"

The criteria cell, E2 can either be blank or have results in it like "Apple" "Banana"

Where there are results, say, Apple, it sums perfectly.

However, where there are blanks, the sum returns 0.

I'd like the sum to return results where one part of the criteria is blank - is this possible? Thank you.

 

[mart37]

$E2-->IF($E2="","",$E2)