Hi

You can use Sumproduct:

=SUMPRODUCT((A1:A100300)+0,(A1:A100<700)+0)

Note that you can't use whole column refs with sumproduct though (ie
so no A:A - the max is A1:A65536).

Alternatively, you could use COUNTIF:

=SUM(COUNTIF(A:A,{"300","=700"})*{1,-1})

Hope this helps!

Richard


On 15 Mar, 15:19, ub wrote:
How Can I have multiple condition using countif function.
Ex: If I want to count only those cells that have value 300 and <700