How to count nos. on 3 criteria

[Guest]

How can i count nos. those are >60 and <100 for a particular Branch.

(so there are three criterias >60, <100 and Branch also)

 

[Carim]

Hi,

=countif(allyourrange,"<100")-countif(allyourange,">60")

HTH

Cheers
Carim

 

[Bob Phillips]

=SUMPRODUCT(--(A2:A20>60),--(A2:A20<100),--(B2:B20="Branch"))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Guest]

Say branch is in A2:A10, Nos in B2:B10, then counting Nos for branch A:

=SUMPRODUCT(--(A2:A10="A"),--(B2:B10>60),--(B2:B10<100))

Adjust ranges as necessary!

Regards,
Stefi

„Excel_Learner†ezt írta:

 

[Ken Wright]

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]

Hi,

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

Cheers
Carim