Missing Something, Can't Find It!!!!

[CARBOB]

Will someone please tell me, what am I missing? The formula in CY 5 and CY 9 are both the same, but different ranges. CY 5 uses data in col's H $ I. CY 9 uses data from col's J & K. I'm getting a value not available.

Excel Workbook
	CW	CX	CY	CZ
3	SKIP	1	2	3
4	HITS	128	100	56
5	SKIP	14	33	26
6	AVG	8.38	10.73	19.16
7	SKIP	1	2	3
8	HITS	135	110	51
9	SKIP	33	#N/A	#N/A
10	AVG	7.95	9.75	21.04
DEGREE OF CERTAINTY

Excel 2007

Cell Formulas
Range	Formula
CX6	=IF(CX4=0,"",COUNT('5 DIGIT PAIRS'!$A:$A)/CX4)
CX10	=IF(CX8=0,"",COUNT('5 DIGIT PAIRS'!$A:$A)/CX8)
CY6	=IF(CY4=0,"",COUNT('5 DIGIT PAIRS'!$A:$A)/CY4)
CY10	=IF(CY8=0,"",COUNT('5 DIGIT PAIRS'!$A:$A)/CY8)
CZ6	=IF(CZ4=0,"",COUNT('5 DIGIT PAIRS'!$A:$A)/CZ4)
CZ10	=IF(CZ8=0,"",COUNT('5 DIGIT PAIRS'!$A:$A)/CZ8)

#VALUE!

Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.

Excel Workbook
Name	Refers To
pair	=#REF!#REF!
Workbook Defined Names

 

[texasalynn]

#REF errors are usually because the area is outside of the formula parameters
or
there is a #REF error within the data area

check those and see if you see the problem with that

 

[CARBOB]

texaslynn, thank you for your response, found the problem. The problem was one of the ranges, CY9, was floating instead of fixed. What a pain!!!

Will someone please tell me, what am I missing? The formula in CY 5 and CY 9 are both the same, but different ranges. CY 5 uses data in col's H $ I. CY 9 uses data from col's J & K. I'm getting a value not available.

Excel Workbook
	CW	CX	CY	CZ
3	SKIP	1	2	3
4	HITS	128	100	56
5	SKIP	14	33	26
6	AVG	8.38	10.73	19.16
7	SKIP	1	2	3
8	HITS	135	110	51
9	SKIP	33	#N/A	#N/A
10	AVG	7.95	9.75	21.04
DEGREE OF CERTAINTY

Excel 2007

Cell Formulas
Range	Formula
CX6	=IF(CX4=0,"",COUNT('5 DIGIT PAIRS'!$A:$A)/CX4)
CX10	=IF(CX8=0,"",COUNT('5 DIGIT PAIRS'!$A:$A)/CX8)
CY6	=IF(CY4=0,"",COUNT('5 DIGIT PAIRS'!$A:$A)/CY4)
CY10	=IF(CY8=0,"",COUNT('5 DIGIT PAIRS'!$A:$A)/CY8)
CZ6	=IF(CZ4=0,"",COUNT('5 DIGIT PAIRS'!$A:$A)/CZ4)
CZ10	=IF(CZ8=0,"",COUNT('5 DIGIT PAIRS'!$A:$A)/CZ8)

#VALUE!

Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.

Excel Workbook
Name	Refers To
pair	=#REF!#REF!
Workbook Defined Names