| Home |
| Search |
| Today's Posts |
|
#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 |
| 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 | |||
Threaded Mode
