Need to cells with no data but with a formula

[JTL9161]

I know I've crossed this bridge before but cannot find anything on it.

I have a table 3 columns 50+ rows. Every cell has a formula has an IF statement in them which either returns data or blank ('")

Problem is if I use a COUNTIF to find the number of blank cells it comes up with "0" because a cell could be "blank" but it has a formula so its not blank.

How do I count how many blank cells that have no data but have a formula?


Thank You,
James

 

[Sergius]

Is this what you wanted?

Book1
	A	B	C	D
1	95.68#88		95.68	88
2
3	99.84#144		99.84	144
4	63.71#999		63.71	999
5	99.84#144		99.84	144
6			4	4
Sheet1

Cell Formulas
Range	Formula
C1:C5	C1	=IFERROR(MID(A1,1,SEARCH("#",A1)-1),"")
D1:D5	D1	=IFERROR(MID(A1,SEARCH("#",A1)+1,100),"")
C6:D6	C6	=SUMPRODUCT(--(C1:C5<>""))

 

[JTL9161]

I'll try and let you know.

 

[Peter_SSs]

Every cell has a formula has an IF statement in them which either returns data or blank ('")

How do I count how many blank cells that have no data but have a formula?

Like this in C11?

24 11 21.xlsm
	C
1
2	a
3
4	3.3
5
6	44
7
8	xyz
9
10
11	6
Count

Cell Formulas
Range	Formula
C1:C10	C1	=IF(B1="","",B1)
C11	C11	=COUNTIF(C1:C10,"")

 

[JTL9161]

Thank you.

 

[Peter_SSs]

You're welcome.
This formula would also return the same value

=COUNTBLANK(C1:C10)