3 added 78 characters in body

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

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.

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)
``````
2 edited body; edited title

# MacOS macOS numbers formula range problem

I can't seem to find the equivalent of:

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

In MacOSmacOS 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.

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

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

1

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