COUNTIF for blank cells

[bines53]

Hello friends,

Does anyone know a way to avoid calculating empty cells?

The range is fixed, the data changes, and there are empty cells,

These formulas do not work properly

=SUM(COUNTIF(B2:B43,D2:D43&"<>*"))

=SUM(COUNTIF(B2:B43,D2:D43&"<>"))

=SUM(COUNTIF(B2:B43,D2:D43&"*"))

Thanks for the helpers

David

 

[bines53]

I found, when the way the way is simple, and looking for the crooked way

=SUM(COUNTIF(B2:B43,D2:D43&" "))

 

[Rickbale]

Try this formula

=IFNA(value, value_if_na)

Regards,
Rick Bale