Sheet Summary Formula to count text cells that are not blank

Melanie Sanders

Hello, I am having a hard time setting up this formula in Sheet Summary

=COUNTIF([Core Customer Name]:[Core Customer Name], "ISNOTBLANK"

Can someone help?

Peggy Parchert

Hello @Melanie Sanders

Try using this formula:

=COUNTIF([Core Customer Name]:[Core Customer Name], <>"")

Hope it helps.

Peggy

Peggy Parchert

Hello @Melanie Sanders

Try using this formula:

=COUNTIF([Core Customer Name]:[Core Customer Name], <>"")

Hope it helps.

Peggy