Hi,

I suspect you mean greater than 100,000 and less then or equal to 200,000?

In 2000:

=SUMPRODUCT(--(A1:A99100000),--(A1:A99<=200000))


--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"jahangir" wrote:

respected sir,
i want to use COUNTIF with two condition in excel
(greater than 100000 but equal to 200000) i want to count the number of
entries in the specified range. please help me