View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Cecilia Cecilia is offline
external usenet poster
 
Posts: 26
Default 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?