Formula Adjustment Needed.

[klatlap]

I have this formula that another user here created for me, basically it counts cells between 2 reference points, just wondering how i may have it just count the non blank cells.

=IF(Data!AS1="","",MATCH("?*",INDEX(Data!AS:AS,1+MATCH(Data!AT1,Data!AS:AS,0)):Data!AS$1048576,0))

 

[FDibbins]

Not sure how that is counting anything? Match returns the (1st) position of a criteria a range, it does not count.

If you need to count stuff, take a look at using the COUNTIFS() function - it counts all non-blank cells...
=countif(range1,criteria1, range2, criteria2..........................)

 

[klatlap]

As you can see with columns A:C the formula in column C works fine

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

But what i need is for the same result in column H, i have just given the example in H of what i need using the data in Columns F:G

Excel 2010
	A	B	C	D	E	F	G	H
1	test1	test1	5			test1	test1	4
2		data					data
3		data
4		data					data
5		data					data
6	test2	test2	4			test2	test2	3
7		data					data
8		data					data
9		data
10	test3	test3	3			test3	test3	3
11		data					data
12		data					data
13	end					end
Sheet1

 

[Peter_SSs]

Try this, copied down to the end of the data in column G.

Excel Workbook
	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
Count

 

[klatlap]

Your formula looks to simple, yet it works better than the original, ty

 

[klatlap]

Oops, sorry i should have said that there is formulas in row G so your COUNTA is also counting them even if they are blank

 

[Peter_SSs]

Oops, sorry i should have said that there is formulas in row G so your COUNTA is also counting them even if they are blank

In that case try this in H1

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

 

[klatlap]

Ty, works a treat

 

[Peter_SSs]

Ty, works a treat

You are welcome. This would also still work for the original question as well.