| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
countaif
plz. i need a help.
How can I use countaif with many conditions or any similar formula? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 --- |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
