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