| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count each cell that have a number and take that number and count. | Excel Discussion (Misc queries) | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| How do I count the number of brackets within a formula (cell)? | Excel Discussion (Misc queries) | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
Linear Mode
