A
A.Mourice
plz. i need a help.
How can I use countaif with many conditions or any similar formula?
How can I use countaif with many conditions or any similar formula?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
rajesh
Try and function within countif.
rajesh
rajesh
M
Max
A.Mourice said: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
---
R
Rick Rothstein \(MVP - VB\)
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
=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
F
Fred Smith
Unfortunately, Rajesh, Countif is not that smart. You need to use Sumproduct
to achieve the desired results.
Regards,
Fred.
to achieve the desired results.
Regards,
Fred.