plz. i need a help.
How can I use countaif with many conditions or any similar formula?

Try and function within countif.

rajesh

"A.Mourice" wrote:

> plz. i need a help.
> How can I use countaif with many conditions or any similar formula?

"A.Mourice" wrote:
> How can I use countaif with many conditions or any similar formula?

You can use sumproduct for multi-criteria counts
Eg in say, C1:
=SUMPRODUCT((A1:A10="Peter")*(B1:B10>50))
will return the counts of lines where col A contains: Peter
AND where col B contains numbers greater than 50
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,500 Files:358 Subscribers:55
xdemechanik
---

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" <(E-Mail Removed)> wrote in message
news:FC69BB43-198E-41DC-9B61-(E-Mail Removed)...
> plz. i need a help.
> How can I use countaif with many conditions or any similar formula?

Unfortunately, Rajesh, Countif is not that smart. You need to use Sumproduct
to achieve the desired results.

Regards,
Fred.

"rajesh" <(E-Mail Removed)> wrote in message
news:B94087E2-90BE-4BD5-A93E-(E-Mail Removed)...
> Try and function within countif.
>
> rajesh
>
> "A.Mourice" wrote:
>
>> plz. i need a help.
>> How can I use countaif with many conditions or any similar formula?