Is there a function that counts the number of cell references in a formula?
C Cecilia Sep 11, 2006 #1 Is there a function that counts the number of cell references in a formula?
B Biff Sep 12, 2006 #2 Is there a function that counts the number of cell references in a formula? Click to expand... Maybe. What's the formula? Biff
Is there a function that counts the number of cell references in a formula? Click to expand... Maybe. What's the formula? Biff
C Cecilia Sep 12, 2006 #3 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
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
B Biff Sep 12, 2006 #4 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
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
R Ron Rosenfeld Sep 12, 2006 #5 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 Click to expand... Or, more generally: =SUMPRODUCT(COLUMNS(rng),ROWS(rng)) --ron
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 Click to expand... Or, more generally: =SUMPRODUCT(COLUMNS(rng),ROWS(rng)) --ron
