How Do I Write This Equation?

[jbradfordbrown]

I have data in 5 columns. If their is no value reported, the cell is blank.
I need to calculate the median if 3 cells or more have reported values. Some rows do not have any values. If the row is 'empty', I want the cell in the median column to be blank and not read #NUM!
Please help me with how to write the logic for this. Have tried different combos of "countif", but cannot get it.
Thank You!

 

[Juan Pablo González]

Mhmm, something like

=IF(COUNT(A1:E1)>=3,MEDIAN(A1:A3),"")

 

[lenze]

=IF(COUNT(A2:E2)>=3,MEDIAN(A2:E2),"")

Book1
	A	B	C	D	E	F	G
1	VAL1	VAL2	VAL3	VAL4	VAL5		MEDIAN
2	5	7		8	9		7.5
3	4	5	7	6	3		5
4
5	4	8	12	2	3		4
...