Using cell value in formula
 

I want to use the COUNTBLANK formula to count the number of empty cells in a
column up until the end of the list of records. I don't know the definite
number of records so i need to dynamically assign the number that the cell
number that the formla should count up to.

ie
COUNT BLANK(D2:Dxxx) where Dxxx is equal to the following function

=MATCH(2,1/(1-ISBLANK(Evaluations_Query!A1:A3417)))+1

how do i generically insert formular into functions or is this even possible?

Using cell value in formula
 

You could try:
=COUNTBLANK(D2:INDIRECT("D"&(MATCH(2,1/(1-ISBLANK(Evaluations_Query!A1:A3417)))+1)))
--
David Biddulph

"Engels" wrote in message
...

I want to use the COUNTBLANK formula to count the number of empty cells in
a
column up until the end of the list of records. I don't know the definite
number of records so i need to dynamically assign the number that the cell
number that the formla should count up to.

ie
COUNT BLANK(D2:Dxxx) where Dxxx is equal to the following function

=MATCH(2,1/(1-ISBLANK(Evaluations_Query!A1:A3417)))+1

how do i generically insert formular into functions or is this even
possible?

Isblank vs CountBlank
 

Per the help files in Excel,
CountBlank will count any cell with a "" as blank,
while IsBlank("")=False.
So I don't think your two formulas are truly equal.

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com

Isblank vs CountBlank
 

So I don't think your two formulas are truly equal.

They're not.

ISBLANK is incorrectly named. It should be named ISEMPTY.

Biff

<Mark C wrote in message ...
Per the help files in Excel,
CountBlank will count any cell with a "" as blank,
while IsBlank("")=False.
So I don't think your two formulas are truly equal.

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com