Want To Count With Two Criteria

  • Thread starter Thread starter AAK1697
  • Start date Start date
A

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
 
THANK YOU. IT WORKED! ONE MORE THING....HOW WOULD I SUM THE ACCOUNT
THAT MET THE SAME CRITERIA
 
=SUMPRODUCT(--(FacilityRange=X2),--(AgencyRange=Y2),AcctBalRange)

where X2 houses a facility of interest and Y2 an agency of interest.
 
=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)
 
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
 
Back
Top