It couldn't be as simple as
=sum(N13+X13+AB13+AH13)/4 ???
Probably not. So you would need to provide more info. Perhaps an array
=average(if ??

--
Don Guillett
SalesAid Software

"Renee - California" wrote in
message ...
Is this possible? I've created a 25 page worksheet to analyze cases and
dollars for 24 stores. The 25 pages are identical; the first page is a
summary of the region (the other 24 pages or stores).

I'm trying to get the averages on the summary page. So I've summarized by
adding each stores cell reference for whatever item I'm looking at. For
example
=N13+X13+AB13+AH13 etc.
and now to get the average, I want to divide by the number of stores that
are actually carrying that item. So I thought I could do a countif,
counting
if the cells in that range are greater than zero. I can't seem to make
this
work though.

What should this formula look like... is there an easier way to do this??