How to count nos. on 3 criteria

E

Excel_Learner

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

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

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)
 
S

Stefi

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:
 
K

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 :)
------------------------------­------------------------------­----------------
 
C

Carim

Hi,

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

Cheers
Carim
 
Top