countaif
 

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

countaif
 

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?

countaif
 

"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:B1050))
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
---

countaif
 

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?

countaif
 

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

Regards,
Fred.

"rajesh" wrote in message
...
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?