countif ignoring blank cells

[rjwalker2514]

	COLUMN A	COLUMN B	COLUMN C	COLUMN D	COLUMN E	COLUMN F	COLUMN G	COLUMN H
ROW 1	34
ROW 2	32	34
ROW 3	12	32	34

I am using a COUNTIF function but do not want it to count the blank cells. Example

I enter into cell E1 =COUNTIF($A$1:D1,A1) the result is correct (1) but then if I drag that across, cells G1&H1 also show (1) as it has counted the blank...

The actual results I want to see are:
E1 (1)
F1 (0)
G1 (0)
H1 (0)
E2 (1)
F2 (2 as its the second time 34 appears)
G2 (0)
H2 (0)
E3 (1)
F3 (2 as its the second time 32 appears)
G3 (3 as its the third time 34 appears)
G4 (0)

thanks for any help

 

[Fluff]

How about

+Fluff.xlsm
	A	B	C	D	E	F	G	H
1	COLUMN A	COLUMN B	COLUMN C	COLUMN D	COLUMN E	COLUMN F	COLUMN G	COLUMN H
2	34				1	0	0	0
3	32	34			1	2	0	0
4	12	32	34		1	2	3	0
Report

Cell Formulas
Range	Formula
E2:H4	E2	=IF(A2="",0,COUNTIF($A$2:D2,A2))

 

[rjwalker2514]

Amazingly quick and works perfectly.

 

[Fluff]

You're welcome & thanks for the feedback