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