Re: Want To Count With Two Criteria
From: Aladin Akyurek (akyurek_at_xs4all.nl)
Date: 08/23/04
- Next message: Bob Phillips: "Re: V Look Up more than one result"
- Previous message: Angus Dow: "Re: Nested IF statements"
- In reply to: AAK1697: "Re: Want To Count With Two Criteria"
- Next in thread: Bob Phillips: "Re: Want To Count With Two Criteria"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 23 Aug 2004 22:04:19 +0200
=SUMPRODUCT(--(FacilityRange=X2),--(AgencyRange=Y2),AcctBalRange)
where X2 houses a facility of interest and Y2 an agency of interest.
"AAK1697 >" <<AAK1697.1bgiov@excelforum-nospam.com> wrote in message
news:AAK1697.1bgiov@excelforum-nospam.com...
> THANK YOU. IT WORKED! ONE MORE THING....HOW WOULD I SUM THE ACCOUNTS
> THAT MET THE SAME CRITERIA?
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>
- Next message: Bob Phillips: "Re: V Look Up more than one result"
- Previous message: Angus Dow: "Re: Nested IF statements"
- In reply to: AAK1697: "Re: Want To Count With Two Criteria"
- Next in thread: Bob Phillips: "Re: Want To Count With Two Criteria"
- Messages sorted by: [ date ] [ thread ]
