sumif with empty cell condition

[waldymar]

Dear All,

I'm a bit stuck with sumif. I want to sum up values but with condition to disregard the empty cell in the corresponding column:

=sumif(AN4:AN16,"<>""",AJ4:AJ16)

Does anyone have any idea why it doesn't work?

Appreciate in advance

 

[Sektor]

Press Ctrl+Shift+Enter:
=SUM(IF(AN4:AN16<>"",AJ4:AJ16,0))

 

[VoG]

Try

=SUMIF(AN4:AN16,"<>",AJ4:AJ16)

 

[waldymar]

Press Ctrl+Shift+Enter:
=SUM(IF(AN4:AN16<>"",AJ4:AJ16,0))

it works, great! but is there any chance to make it with SUMIF?

 

[waldymar]

Try

=SUMIF(AN4:AN16,"<>",AJ4:AJ16)

It doesn't work, unfortunately. remark: the empty cell is made by the formula.

 

[Sektor]

Try VoG's formula.

 

[VoG]

Try

=SUMPRODUCT(--(AN4:AN16<>""),AJ4:AJ16)

 

[waldymar]

Try

=SUMPRODUCT(--(AN4:AN16<>""),AJ4:AJ16)

this one works!
we can say that SUMIF doesn't help us in this case?

Thanks to both of you!