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