Count non-formula cells in range???

[MarkReddell]

Good evening fellow excelers,

Is there a way to write an XL formula that will count non-formulas in a range?

I know this is gotta be simple to do, but I just can’t seem to wrap my mind around how to do it after about half an hour to an hour of trying.

Thanks for any consideration to this issue that I’m trying to call.

Have a great evening everyone, and Merry Christmas to all!

 

[mehidy1437]

Try this,
=COUNTA(range) - COUNT(range)

 

[StephenCrump]

.. but I just can’t seem to wrap my mind around how to do it after about half an hour to an hour of trying.

What did you try?

The starting point would be ISFORMULA(). But this may need further refinement depending on exactly which cells you want to include?

	A	B
1
2		1
3		2
4		#DIV/0!
5		4
6		A
7		6
8		7
9		#NAME?
10		B
11
12
13		#N/A
14		C
15		D
16
17	Non-formulae	6
18
Sheet1

Cell Formulas
Range	Formula
B3,B8	B3	=B2+1
B4	B4	=1/0
B6	B6	="A"
B9	B9	=InvalidName
B10	B10	="B"
B12	B12	=""
B14	B14	="C"
B17	B17	=SUM(--NOT(ISFORMULA(rng)))

Named Ranges
Name	Refers To	Cells
rng	=Sheet1!$B$2:$B$15	B17, B3