Tweeted twitter.com/askdifferent/status/863465241295945728
3 added 78 characters in body
source | link

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

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

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.