Problem.... Nested countifs?

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.
>
>
>

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.
>>
>>
>>
>
>

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.
> >>
> >>
> >>
> >
> >
>
>