count amount of cells

J

Jonsson

Hi,

How to count cells that contains formulas but only the ones tha
returns a value?

I thought I could use function "counta", but that function counts al
cells, probably becouse all cells containing formulas.

Any ideas?

//Thoma
 
J

JulieD

Hi

hope you don't think this is a silly question but what do the cells
containing formulas return if not a value?
if you mean return a number greater than 0 then a countif might be the
answer
=COUNTIF(A1:A100,">"&0)

Cheers
JulieD
 
J

James R-S

It's pretty easy to determine how many cells return text or numbers, for
example.

(These must be entered as array formulas - omit the curly braces and hit
cntl+chift+enter when done)

{=SUM(IF(ISTEXT(R11C5:R15C5),1,0))}
{=SUM(IF(ISNUMBER(R11C5:R15C5),1,0))}
{=SUM(IF(ISBLANK(R11C5:R15C5),1,0))}

I can't find an easy way to determine that a cell contains a formula or a
constant. Stumped on that one.

James R-S.
 
Top