Excel formula help needed.
 

I currently use this formula

=IF(A1="","",IF(A1="end","",MATCH("?*",INDEX(A:A,1+MATCH(B1,A:A,0)):A$1048576,0)))
to get this result.

Excel 2010

	A	B	C
1	test1	test1	5
2		data
3		data
4		data
5		data
6	test2	test2	4
7		data
8		data
9		data
10	test3	test3	3
11		data
12		data
13	end

Sheet1

But what i need is for it to be modified to ignore blank spaces so i can get this result.

Excel 2010

	F	G	H
1	test1	test1	4
2		data
3
4		data
5		data
6	test2	test2	3
7		data
8		data
9
10	test3	test3	3
11		data
12		data
13	end

Sheet1

I hacked at your code and got the following, which appears to work:

Got to love those guys on the MrExcel forum.

=IF(F1="","",COUNTA(G1:G$13)-SUM(H2:H$13))

Thamks for the help walkermac

Sorry, both those formulas still count the space because it has a formula in it.

They came up with a similar code to your, just more compact.

=IF(F1="","",COUNTIF(G1:G$13,"?*")-SUM(H2:H$13))