glad to help

--
Don Guillett
SalesAid Software
donaldb@281.com
"Nick" <morpheseus@hotmail.com> wrote in message
news:hsY3e.892488$8l.266722@pd7tw1no...
> Thanks Don! This works perfectly. I modified the second half to give me
a
> range and that works too. I queried "Q2:Q500" for a value and then asked
> for it to search the range "M2:P500". It added perfectly. This solves a
> huge problem for me and save me a lot of time doing it manually.
>
> I am very thankful for you suggestion!
>
> Nick.
>
>
> "Don Guillett" <donaldb@281.com> wrote in message
> news:eFPYIE7NFHA.3356@TK2MSFTNGP12.phx.gbl...
> > try
> > =sumproduct((q2:q200="X")*(m2:m200="Low"))
> >
> > --
> > Don Guillett
> > SalesAid Software
> > donaldb@281.com
> > "Nick" <morpheseus@hotmail.com> wrote in message
> > news:BbB3e.878545$Xk.1243@pd7tw3no...
> >> I want to be able to count the number of clients who are marked as "X"
in
> >> column Q .... and who are marked as "Low" in column M.
> >>
> >> I tried countif... but it counted the number of clients marked Low and
> > added
> >> it to the number of X's.
> >>
> >>
> >> tia
> >> Nick.
> >>
> >>
> >>
> >
> >
>
>