function to count the number of cell references in a formula
 

Is there a function that counts the number of cell references in a formula?

function to count the number of cell references in a formula
 

Is there a function that counts the number of cell references in a
formula?

Maybe. What's the formula?

Biff

"Cecilia" wrote in message
...
Is there a function that counts the number of cell references in a
formula?

function to count the number of cell references in a formula
 

One of the formulas is listed below. Is there a formula that would tell me
how many cells it's adding?

=SUM(S175:Z175)

In this instance it's expressed as a range and it's 8


"Biff" wrote:

Is there a function that counts the number of cell references in a
formula?

Maybe. What's the formula?

Biff

"Cecilia" wrote in message
...
Is there a function that counts the number of cell references in a
formula?

function to count the number of cell references in a formula
 

Try this:

=COLUMNS(S175:Z175)

If the range of cells was S175:S185

=ROWS(S175:S185)

If the range of cells was C2:E10

=COLUMNS(C2:E10)*ROWS(C2:E10)

Biff

"Cecilia" wrote in message
...
One of the formulas is listed below. Is there a formula that would tell me
how many cells it's adding?

=SUM(S175:Z175)

In this instance it's expressed as a range and it's 8


"Biff" wrote:

Is there a function that counts the number of cell references in a
formula?

Maybe. What's the formula?

Biff

"Cecilia" wrote in message
...
Is there a function that counts the number of cell references in a
formula?

function to count the number of cell references in a formula
 

On Tue, 12 Sep 2006 14:21:35 -0400, "Biff" wrote:

Try this:

=COLUMNS(S175:Z175)

If the range of cells was S175:S185

=ROWS(S175:S185)

If the range of cells was C2:E10

=COLUMNS(C2:E10)*ROWS(C2:E10)

Biff


Or, more generally:

=SUMPRODUCT(COLUMNS(rng),ROWS(rng))


--ron