Excel Countif between time ranges

[mrsushi]

Hi,

I have the following issue where the countif function isnt working. The formula is correct, but the column to which its referencing is based on an Average formula. Not sure how to get pass this issue. Any assistance will be appreciated.

The formula in column C is =AVERAGE(D2:E2).

As a result, the return value is producing a circular reference.

Any ideas please?

 

[etaf]

not sure why that would give a circular reference

Book3
	A	B	C	D	E	F	G
1
2			13:07	12:00	14:15		1
Sheet1

Cell Formulas
Range	Formula
C2	C2	=AVERAGE(D2:E2)
G2	G2	=COUNTIFS(C2:C7,">="&TIME(9,0,0))

 

[mrsushi]

not sure why that would give a circular reference

Book3
	A	B	C	D	E	F	G
1
2			13:07	12:00	14:15		1
Sheet1

Cell Formulas
Range	Formula
C2	C2	=AVERAGE(D2:E2)
G2	G2	=COUNTIFS(C2:C7,">="&TIME(9,0,0))

Just realised i had the Average formula D2-Z2 (which overlapped the CountIF formula

Regards
M

 

[etaf]

you are welcome
glad its sorted