• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

COUNTIF for blank cells

bines53

Active Member
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
 

Attachments

R

Rickbale

Guest
Try this formula

=IFNA(value, value_if_na)

Regards,
Rick Bale
 
Top