Counting inputted cells

[happyman123uk]

I have a table that has a range of cells in it

	a	b	c	d	e	f	g	h	i	j	k	l	m	n	o	p	q	r	s	t	u	v	w	x	y
1	12												18												47
2			72								67											67
3							70							45		45								56
4		34																	56
5												56												67
6					total inputted cells is	14

<tbody>
</tbody>

So my question is: how do I count the cells that have been inputted with numbers and keep a running total in say cell F6

 

[DanteAmor]

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y
1	12												18												47
2			72								67											67
3							70							45		45								56
4		34																	56
5												56												67
6					total inputted cells is	14
Sheet

 

[happyman123uk]

Sheet

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y
1	12												18												47
2			72								67											67
3							70							45		45								56
4		34																	56
5												56												67
6					total inputted cells is	14

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:32px;"><col style="width:32px;"><col style="width:32px;"><col style="width:32px;"><col style="width:67px;"><col style="width:32px;"><col style="width:32px;"><col style="width:32px;"><col style="width:32px;"><col style="width:32px;"><col style="width:32px;"><col style="width:32px;"><col style="width:32px;"><col style="width:32px;"><col style="width:32px;"><col style="width:32px;"><col style="width:32px;"><col style="width:32px;"><col style="width:32px;"><col style="width:32px;"><col style="width:32px;"><col style="width:32px;"><col style="width:32px;"><col style="width:32px;"><col style="width:32px;"></colgroup><tbody>
</tbody>

Formeln der Tabelle

Zelle Formel F6 =COUNT(A1:Y5) <tbody> </tbody>

<tbody>
</tbody>

Excel Tabellen im Web darstellen >> Excel Jeanie HTML 4.8

Thanks but what if I have a gap in the data say I cant input column e,j,u as they already contain text or data I don't want to include in the count

 

[DanteAmor]

Thanks but what if I have a gap in the data say I cant input column e,j,u as they already contain text or data I don't want to include in the count

this is a way
=COUNT(A1:D5,F1:I5,K1:T5,V1:Y5)

 

[happyman123uk]

Thank you very much another little problem solved

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.