Counting Cells Not Empty

Platform discussions
, ,
1

Is there a way to count the cells in a row that are not empty. For example I am in Column B & Row 1 and I want to count all the celts to the right of Column B & Row 1. Since CountIf is not yet a feature, is there a way i can work around this?

2

Hi Stephen,

It depends on the type of column, but if they are text fields, for instance, you could create a formula like this:

SUM(IF({Text 1}="",1,0),IF({Text 2}="",1,0),IF({Text 3}="",1,0))

Want to take your formulas to the next level? Try the Advanced Formula Booster, the app that reinvents formulas in monday.

  • Create formulas without using the Formula column (and avoid its limitations)
  • Build formulas involving data from the previous item, the next item, the sub-items, the parent item, even items in the same group or the same board.
  • In one formula, update multiple columns from multiple items.

Check our blog for real use cases.