This is counting now, but it's returning a count of "1" only.

A little more insight on this project:

Each worksheet represents a territory.
Each territory can contain up to 24 customers;
The data collected for each customer is a list of all the items I have to
offer, the price that particular customer pays for the item, and the amount
of facings they have of each item. Not every customer picks up every item.

What I'm trying to count is how many customers in that territory actually
picked up any given item.

Any more ideas??? I really appreciate your help.

"Ken Wright" wrote:

> Juts realised your text doesn't tie with your title, so if it;s every 10th
> where >0 then try
>
> =SUMPRODUCT(--(MOD(COLUMN($Q$13:$IM$13),10)=7),--($Q$13:$IM$13>0))
>
> --
> Regards
> Ken....................... Microsoft MVP - Excel
> Sys Spec - Win XP Pro / XL 97/00/02/03
>
> ------------------------------Â*------------------------------Â*----------------
> It's easier to beg forgiveness than ask permission :-)
> ------------------------------Â*------------------------------Â*----------------
>
> "Renee - California" <ReneeCalifornia@discussions.microsoft.com> wrote in
> message news:9E306592-C43C-4187-9494-D7ED9BEFBDEA@microsoft.com...
> > 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" <ReneeCalifornia@discussions.microsoft.com> wrote in
> >> message news:2C972820-ABD0-4381-9EDD-64ADD2A703F9@microsoft.com...
> >> > 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.
> >>
> >>
> >>
>
>
>