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)

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)

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)

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)

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)

How to count nos. on 3 criteria
 

Hi,

Ken is right ... I read too quickly your post ...
Solution is with sumproduct()

Cheers
Carim