Counting number of cells with formula returning a value OR a #DIV/0 error?

[povictory]

I have a range of cells with IF formulas that will either return a value based on other cell inputs or will remain blank. I'm trying to figure out how to count the number of cells in the range that either are returning a value *OR* are returning a #DIV/0 error. The blank cells should be ignored and not included in the count.

I've done some testing and searching around for a solution but I'm not having luck. I can easily count cells that return a value or cells that return a #DIV/0 error, but I'm having trouble figuring out a formula that will count both and return the total number of values and #DIV/0 errors at the same time.

Any advice or suggestions to try would be greatly appreciated!

 

[Eric W]

A couple ideas:

Book1
	A	B	C	D	E
1	Values	Source
2	1	1		6	6
3	0.5	2
4	0.333333	3
5
6	#DIV/0!	0
7
8	0.2	5
9	#DIV/0!	0
Sheet4

Cell Formulas
Range	Formula
D2	D2	=ROWS(A2:A9)-COUNTBLANK(A2:A9)
E2	E2	=SUM(--ISNUMBER(A2:A9))+SUM(--ISERROR(A2:A9))
A2:A9	A2	=IF(B2="","",1/B2)

 

[povictory]

A couple ideas:

Book1
	A	B	C	D	E
1	Values	Source
2	1	1		6	6
3	0.5	2
4	0.333333	3
5
6	#DIV/0!	0
7
8	0.2	5
9	#DIV/0!	0
Sheet4

Cell Formulas
Range	Formula
D2	D2	=ROWS(A2:A9)-COUNTBLANK(A2:A9)
E2	E2	=SUM(--ISNUMBER(A2:A9))+SUM(--ISERROR(A2:A9))
A2:A9	A2	=IF(B2="","",1/B2)

Exactly what I was looking for...thank you!

 

[Eric W]

Happy to help!