Hi Renee,

I suspect you've tried this:

=COUNT(IF((MOD(COLUMN(Q13:IM13),10)=7)*(Q13:IM130 ),Q13:IM13))

array-entered, so if that's not working, might there be a non-numeric value
in one or more of the cells you're counting, such that COUNT would then
return an undercount? Specifically what formula are you using to get a
count, and what is it returning? An error value? An erroneous value?

--
C^2
Conrad Carlberg

Excel Sales Forecasting for Dummies, Wiley, 2005


"Renee - California" wrote in
message ...
No, that's the problem, it's not that straight forward. I want to count
Q13,
AA13, AK13... all the way to IM13.

The formula I used before indicates the start and end column, addressing
every 10th column, etc. but I can't recreate it just to do a count now.
YIKES!!!


"CLR" wrote:

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.