| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to count nos. on 3 criteria
How can i count nos. those are 60 and <100 for a particular Branch.
(so there are three criterias 60, <100 and Branch also) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to count nos. on 3 criteria
Hi,
=countif(allyourrange,"<100")-countif(allyourange,"60") HTH Cheers Carim Excel_Learner wrote: How can i count nos. those are 60 and <100 for a particular Branch. (so there are three criterias 60, <100 and Branch also) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to count nos. on 3 criteria
=SUMPRODUCT(--(A2:A2060),--(A2:A20<100),--(B2:B20="Branch"))
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Excel_Learner" wrote in message ... How can i count nos. those are 60 and <100 for a particular Branch. (so there are three criterias 60, <100 and Branch also) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to count nos. on 3 criteria
Say branch is in A2:A10, Nos in B2:B10, then counting Nos for branch A:
=SUMPRODUCT(--(A2:A10="A"),--(B2:B1060),--(B2:B10<100)) Adjust ranges as necessary! Regards, Stefi €žExcel_Learner€ť ezt Ă*rta: How can i count nos. those are 60 and <100 for a particular Branch. (so there are three criterias 60, <100 and Branch also) |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to count nos. on 3 criteria
Doesn't cater for the third criteria as specified by the OP. See Bob or
Stefi's post for an answer that does though. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------*------------------------------*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------*------------------------------*---------------- "Carim" wrote in message ups.com... Hi, =countif(allyourrange,"<100")-countif(allyourange,"60") HTH Cheers Carim Excel_Learner wrote: How can i count nos. those are 60 and <100 for a particular Branch. (so there are three criterias 60, <100 and Branch also) |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to count nos. on 3 criteria
Hi,
Ken is right ... I read too quickly your post ... Solution is with sumproduct() Cheers Carim |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count if two columns match different criteria | Excel Worksheet Functions | |||
| Count items when specific text and date criteria are met | Excel Worksheet Functions | |||
| How do I count data with criteria from two separate columns in exc | Excel Worksheet Functions | |||
| Count rows that match criteria in 2 different column cell ranges | New Users to Excel | |||
| count cell if value present in every other cell + criteria | Excel Worksheet Functions | |||
Linear Mode
