SUM IF Text to exclude ""

[pauldaddyadams]

Hi,

I had this sumif formula:
=SUMIF(Data!C7:$C$435,"<>",Data!$CV$7:$CV$435)

but I now need it to exclude "". On a vlookup I have IFERROR return "" and thererore this is still being picked up. How can I exclude it?

[XOR LX]

Hi.

Apart from "" strings, what type of data is in Data!C7:C435? Text? Numbers? Both?

Regards

[pauldaddyadams]

Hi,

Its both.

I need it to sum every unless its either blank or ""

[samba_ravi]

=SUMIF(Data!C7:$C$435,"<>"&"",Data!$CV$7:$CV$435)
try

[pauldaddyadams]

Hi,

That didnt work im affraid

[samba_ravi]

or try
=SUMPRODUCT((LEN(data!C7:$C$435)>0)*(data!$CV$7:$CV$435))

[pauldaddyadams]

Perfect! This did it, I like it! never thought of doing it that way before

[samba_ravi]

or
=SUMPRODUCT((data!C7:$C$435<>"")*(data!$CV$7:$CV$435))