If you are just wanting to count the number of cells in the range Q13:IM:13
that contain value larger than zero.........

=COUNTIF(Q13:IM13,"0")

Vaya con Dios,
Chuck, CABGx3


"Renee - California" wrote in
message ...
I need to count specific cells in a row. I had a similar formula to
average
the same cells I am now trying to count:

=AVERAGE(IF((MOD(COLUMN(Q13:IM13),10)=7)*(Q13:IM13 0),Q13:IM13))

I tried tweaking this to count, but it's just not coming out with a valid
answer.

Any help would be appreciated.

Thanks!

Renee.