Want To Count With Two Criteria

[AAK1697]

FACILITY ACCT BAL AGENCY
G $156.00 OSI
R $156.00 PCB
G $156.00 OSI
G $156.00 PCB
R $156.00 OSI
G $156.00 OSI


I wiould like to write a formula that will COUNT the number of account
that are with FACILITY G as well as AGENCY OSI. Please help

 

[Don Guillett]

try
=sumproduct((a2:a200="G")*(b2:b200="OSI"))

 

[AAK1697]

THANK YOU. IT WORKED! ONE MORE THING....HOW WOULD I SUM THE ACCOUNT
THAT MET THE SAME CRITERIA

 

[Aladin Akyurek]

=SUMPRODUCT(--(FacilityRange=X2),--(AgencyRange=Y2),AcctBalRange)

where X2 houses a facility of interest and Y2 an agency of interest.

 

[Bob Phillips]

=sumproduct(--(a2:a200="G"),--(c2:c200="OSI"),b2:b200)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[AAK1697]

THANK YOU!

 

[Don Guillett]

Please don't SHOUT by typing in all caps. Just add
=sumproduct((a2:a200="G")*(b2:b200="OSI")) to count
=sumproduct((a2:a200="G")*(b2:b200="OSI")*b2:b200) to sum b