Hello,

Can you combine a countif and if statement?
Such as:
=Countif(AA4:AF4,"0") this yields an answer.
=IF(AF290,AF29, IF($F29=AH$3,($V29+$W29+$X29+$Y29)/6,0))

I would like only answers in the countif statement that are = to 6 to yield
a 0 and not perform the IF statement. But if the countif statement yields
less than a 6, to continue with the IF statement.

I hope that makes sense.

Any help would be great.

Thanks in advance.
--
Heather

Hi Heather

how about
=IF(COUNTIF(AA4:AF4,"0")<6,IF(AF290,AF29,
IF($F29=AH$3,($V29+$W29+$X29+$Y29)/6,0)),0)

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Heather" wrote in message
...
Hello,

Can you combine a countif and if statement?
Such as:
=Countif(AA4:AF4,"0") this yields an answer.
=IF(AF290,AF29, IF($F29=AH$3,($V29+$W29+$X29+$Y29)/6,0))

I would like only answers in the countif statement that are = to 6 to
yield
a 0 and not perform the IF statement. But if the countif statement yields
less than a 6, to continue with the IF statement.

I hope that makes sense.

Any help would be great.

Thanks in advance.
--
Heather