If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
countaif
plz. i need a help.
How can I use countaif with many conditions or any similar formula? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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 --- |
#4
|
|||
|
|||
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:A205) 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? |
#5
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|