Sumifs vs Sumproduct on partially blank cell

[Interrogation]

Hey All,

I have the below table, and instead of having "B", I have formula that goes : If(xxx,"Text", ""), and as it stands B should then reflect: "".
When I use the formula: sumifs(range Y,Range Y, "<>"), the formula reverts 3; but if I use sumproduct ((range X <> "")*(Range Y)) the formula reverts the appropriate 2.

I dont understand why and I would like to keep using sumifs and not having to add a column.

Do you have any solution?

Range X	Range Y
A	1
B	1
C	1

 

[Fluff]

As the cell is not blank you need to use "?*" rather than "<>"

 

[Interrogation]

Thanks it does work, I was just wondering why then on suproduct the <>"" works?

 

[Fluff]

You're welcome & thanks for the feedback.
Why the xxxIFS functions work differently to other regarding blank/empty cells I don't know.