This formula counts blank cell since the last entry in the colmn.
=IF(L3<"",COUNTBLANK(INDEX($L$2:L2,MATCH(9.999999 99999999E+307,$L$2:L2))
:L3),"")

I find myself needing to manually copy it down to get it to accept the
newest entry.

I have put the formula into a new sheet and make reference to the original
sheet.
=IF(Sheet1!L3<"",COUNTBLANK(INDEX(Sheet1!$L$2:L2, MATCH(9.99999999999999E+307,Sheet1!$L$2:L2))
:Sheet1!L3),"")

Is there a way to make this formula say, a full row reference, that will
automatically count blank cells since the last entry so I don't have to
continually update the formula?

Hope this makes since,
Thank you now, and well into the future for your graciousness,
Luke

It's not clear what you want.

I mean, it's obvious you're counting empty/blank cells but it's not clear
what range you want to use for the count. It seems you want to define an end
of range and count from the last numeric entry to the end of range but
you're formula is using a different end of range each time you copy the
formula down the column.

Need more details.

--
Biff
Microsoft Excel MVP


"Luke" wrote in message
...
This formula counts blank cell since the last entry in the colmn.
=IF(L3<"",COUNTBLANK(INDEX($L$2:L2,MATCH(9.999999 99999999E+307,$L$2:L2))
:L3),"")

I find myself needing to manually copy it down to get it to accept the
newest entry.

I have put the formula into a new sheet and make reference to the original
sheet.
=IF(Sheet1!L3<"",COUNTBLANK(INDEX(Sheet1!$L$2:L2, MATCH(9.99999999999999E+307,Sheet1!$L$2:L2))
:Sheet1!L3),"")

Is there a way to make this formula say, a full row reference, that will
automatically count blank cells since the last entry so I don't have to
continually update the formula?

Hope this makes since,
Thank you now, and well into the future for your graciousness,
Luke

Thanks T. Valko,
Try this:
Sheet1 A:A is automatically updated with numeric information as it occurs
(by a completely different formula).
In sheet2 $A$1 I need a formula that will count blank cells since the last
entry in Sheet1 A:A WITHOUT copying/Filling the formula down in Sheet2 $A$1.

In otherwords, the formula in Sheet2 $A$1 needs to stay static/stay-put
regardless of movement in Sheet1 A:A

I hope this is more clear
Luke

"T. Valko" wrote:

It's not clear what you want.

I mean, it's obvious you're counting empty/blank cells but it's not clear
what range you want to use for the count. It seems you want to define an end
of range and count from the last numeric entry to the end of range but
you're formula is using a different end of range each time you copy the
formula down the column.

Need more details.

--
Biff
Microsoft Excel MVP


"Luke" wrote in message
...
This formula counts blank cell since the last entry in the colmn.
=IF(L3<"",COUNTBLANK(INDEX($L$2:L2,MATCH(9.999999 99999999E+307,$L$2:L2))
:L3),"")

I find myself needing to manually copy it down to get it to accept the
newest entry.

I have put the formula into a new sheet and make reference to the original
sheet.
=IF(Sheet1!L3<"",COUNTBLANK(INDEX(Sheet1!$L$2:L2, MATCH(9.99999999999999E+307,Sheet1!$L$2:L2))
:Sheet1!L3),"")

Is there a way to make this formula say, a full row reference, that will
automatically count blank cells since the last entry so I don't have to
continually update the formula?

Hope this makes since,
Thank you now, and well into the future for your graciousness,
Luke

Maybe this:

=IF(COUNT(Sheet1!A:A),COUNTBLANK(Sheet1!A1:INDEX(S heet1!A:A,MATCH(1E+100,Sheet1!A:A))),"")

--
Biff
Microsoft Excel MVP


"Luke" wrote in message
...
Thanks T. Valko,
Try this:
Sheet1 A:A is automatically updated with numeric information as it occurs
(by a completely different formula).
In sheet2 $A$1 I need a formula that will count blank cells since the last
entry in Sheet1 A:A WITHOUT copying/Filling the formula down in Sheet2
$A$1.

In otherwords, the formula in Sheet2 $A$1 needs to stay static/stay-put
regardless of movement in Sheet1 A:A

I hope this is more clear
Luke

"T. Valko" wrote:

It's not clear what you want.

I mean, it's obvious you're counting empty/blank cells but it's not clear
what range you want to use for the count. It seems you want to define an
end
of range and count from the last numeric entry to the end of range but
you're formula is using a different end of range each time you copy the
formula down the column.

Need more details.

--
Biff
Microsoft Excel MVP


"Luke" wrote in message
...
This formula counts blank cell since the last entry in the colmn.
=IF(L3<"",COUNTBLANK(INDEX($L$2:L2,MATCH(9.999999 99999999E+307,$L$2:L2))
:L3),"")

I find myself needing to manually copy it down to get it to accept the
newest entry.

I have put the formula into a new sheet and make reference to the
original
sheet.
=IF(Sheet1!L3<"",COUNTBLANK(INDEX(Sheet1!$L$2:L2, MATCH(9.99999999999999E+307,Sheet1!$L$2:L2))
:Sheet1!L3),"")

Is there a way to make this formula say, a full row reference, that
will
automatically count blank cells since the last entry so I don't have to
continually update the formula?

Hope this makes since,
Thank you now, and well into the future for your graciousness,
Luke

T. Valko,
I thought you had it for a minute there but it is returning the MAX value of
the colmn. i.e. the blank cells equal 23 since the last entry and the formula
is returning 8113 which just happens to be the max value in the column
selection.
It took me a bit to catch on what it was returning.

any solutions? I can up load if you need.
Luke
"T. Valko" wrote:

Maybe this:

=IF(COUNT(Sheet1!A:A),COUNTBLANK(Sheet1!A1:INDEX(S heet1!A:A,MATCH(1E+100,Sheet1!A:A))),"")

--
Biff
Microsoft Excel MVP


"Luke" wrote in message
...
Thanks T. Valko,
Try this:
Sheet1 A:A is automatically updated with numeric information as it occurs
(by a completely different formula).
In sheet2 $A$1 I need a formula that will count blank cells since the last
entry in Sheet1 A:A WITHOUT copying/Filling the formula down in Sheet2
$A$1.

In otherwords, the formula in Sheet2 $A$1 needs to stay static/stay-put
regardless of movement in Sheet1 A:A

I hope this is more clear
Luke

"T. Valko" wrote:

It's not clear what you want.

I mean, it's obvious you're counting empty/blank cells but it's not clear
what range you want to use for the count. It seems you want to define an
end
of range and count from the last numeric entry to the end of range but
you're formula is using a different end of range each time you copy the
formula down the column.

Need more details.

--
Biff
Microsoft Excel MVP


"Luke" wrote in message
...
This formula counts blank cell since the last entry in the colmn.
=IF(L3<"",COUNTBLANK(INDEX($L$2:L2,MATCH(9.999999 99999999E+307,$L$2:L2))
:L3),"")

I find myself needing to manually copy it down to get it to accept the
newest entry.

I have put the formula into a new sheet and make reference to the
original
sheet.
=IF(Sheet1!L3<"",COUNTBLANK(INDEX(Sheet1!$L$2:L2, MATCH(9.99999999999999E+307,Sheet1!$L$2:L2))
:Sheet1!L3),"")

Is there a way to make this formula say, a full row reference, that
will
automatically count blank cells since the last entry so I don't have to
continually update the formula?

Hope this makes since,
Thank you now, and well into the future for your graciousness,
Luke

I can up load if you need.

OK, that'd be a good idea.

This should be relatively easy but I'm just not understanding exactly what
you want. Seeing things will help.


--
Biff
Microsoft Excel MVP


"Luke" wrote in message
...
T. Valko,
I thought you had it for a minute there but it is returning the MAX value
of
the colmn. i.e. the blank cells equal 23 since the last entry and the
formula
is returning 8113 which just happens to be the max value in the column
selection.
It took me a bit to catch on what it was returning.

any solutions? I can up load if you need.
Luke
"T. Valko" wrote:

Maybe this:

=IF(COUNT(Sheet1!A:A),COUNTBLANK(Sheet1!A1:INDEX(S heet1!A:A,MATCH(1E+100,Sheet1!A:A))),"")

--
Biff
Microsoft Excel MVP


"Luke" wrote in message
...
Thanks T. Valko,
Try this:
Sheet1 A:A is automatically updated with numeric information as it
occurs
(by a completely different formula).
In sheet2 $A$1 I need a formula that will count blank cells since the
last
entry in Sheet1 A:A WITHOUT copying/Filling the formula down in Sheet2
$A$1.

In otherwords, the formula in Sheet2 $A$1 needs to stay static/stay-put
regardless of movement in Sheet1 A:A

I hope this is more clear
Luke

"T. Valko" wrote:

It's not clear what you want.

I mean, it's obvious you're counting empty/blank cells but it's not
clear
what range you want to use for the count. It seems you want to define
an
end
of range and count from the last numeric entry to the end of range but
you're formula is using a different end of range each time you copy
the
formula down the column.

Need more details.

--
Biff
Microsoft Excel MVP


"Luke" wrote in message
...
This formula counts blank cell since the last entry in the colmn.
=IF(L3<"",COUNTBLANK(INDEX($L$2:L2,MATCH(9.999999 99999999E+307,$L$2:L2))
:L3),"")

I find myself needing to manually copy it down to get it to accept
the
newest entry.

I have put the formula into a new sheet and make reference to the
original
sheet.
=IF(Sheet1!L3<"",COUNTBLANK(INDEX(Sheet1!$L$2:L2, MATCH(9.99999999999999E+307,Sheet1!$L$2:L2))
:Sheet1!L3),"")

Is there a way to make this formula say, a full row reference, that
will
automatically count blank cells since the last entry so I don't have
to
continually update the formula?

Hope this makes since,
Thank you now, and well into the future for your graciousness,
Luke