# macOS numbers formula range problem

I can't seem to find the equivalent of:

``````H2:2
``````

In macOS Numbers app. This statement in a formula tells that the formula should take the cells from H2 to the end of the row into consideration.

I can't set it to a constant value, since the rows are constantly increasing, so I need a dynamic value.

EDIT: This is what I was using in Google Sheets:

``````=COUNTIF(I3:3, 0)
``````
• Just to be sure I understand, the row (horizontally) or column (vertically)? You mention increasing rows so that is what is confusing. If the rows increase That does not affect another row, increasing columns would. Would love to help if we can, please clarify perhaps with an example table. Cheers
– bjbk
May 9, 2017 at 14:23

So, while `COUNTIF(I3:3, 0)` will resolve to an error, `COUNTIF(3:3, 0)` will work regardless of the row's length. (Increasing columns)
Just give the column name. This: `SUM(H2;)` should give you the sum of all values in column H2. You do not need to provide a range.