You would use the SUMPRODUCT formula. There are two forms for it...

=SUMPRODUCT(Condition1*Condition2*etc)

or

=SUMPRODUCT(--Condition1,--Condition2,--etc)

where, for your stated question, Condition1/2/etc. are logical multi-range
expressions such as this...

(A1:A20<5)

Here is some more detailed information about SUMPRODUCT...

http://xldynamic.com/source/xld.SUMPRODUCT.html

Rick


"A.Mourice" wrote in message
...
plz. i need a help.
How can I use countaif with many conditions or any similar formula?