(Msg. 1) Posted: Sun Nov 01, 2009 1:14 pm
Post subject: DCOUNTA with multiple criteria Archived from groups: microsoft>public>excel>worksheet>functions (more info?)
Can anyone explain how to do a DCOUNTA formula with multiple criteria? I need
to count the number of people that have PPO insurance that live in Ft. Worth
or Bedford on a worksheet.
(Msg. 2) Posted: Sun Nov 01, 2009 5:11 pm
Post subject: Re: DCOUNTA with multiple criteria [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Assume the PPO and City info exists in A1:B10 with A1 = "PPO" and B1 =
"City". Enter the following in F15:G17:
PPO City
TRUE Fort Worth
TRUE Bedford
Then, use the following DCOUNTA formula:
=DCOUNTA(A1:B10,2,F15:G17)
This will return the number of values in A1:A10 where column A is TRUE
and column B is either 'Fort Worth' or 'Bedford'.
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
On Sun, 1 Nov 2009 13:14:01 -0800, stumped in texas <stumped in
texas.TakeThisOut@discussions.microsoft.com> wrote:
>Can anyone explain how to do a DCOUNTA formula with multiple criteria? I need
>to count the number of people that have PPO insurance that live in Ft. Worth
>or Bedford on a worksheet.
(Msg. 3) Posted: Sun Nov 01, 2009 5:14 pm
Post subject: RE: DCOUNTA with multiple criteria [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
--Using SUMPRODUCT() for 2 criterias
=SUMPRODUCT((A1:A10=criteria1)*(B1:B10=criteria2))
=SUMPRODUCT((A1:A10=F1)*(B1:B10=F2))
--If you are using Excel 2007 check out help on COUNTIFS()
If this post helps click Yes
---------------
Jacob Skaria
"stumped in texas" wrote:
> Can anyone explain how to do a DCOUNTA formula with multiple criteria? I need
> to count the number of people that have PPO insurance that live in Ft. Worth
> or Bedford on a worksheet.
(Msg. 4) Posted: Sun Nov 01, 2009 6:00 pm
Post subject: Re: DCOUNTA with multiple criteria [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
There are other worksheet functions that may be easier to use. If you're using
xl2007, look at =sumifs().
stumped in texas wrote:
>
> Can anyone explain how to do a DCOUNTA formula with multiple criteria? I need
> to count the number of people that have PPO insurance that live in Ft. Worth
> or Bedford on a worksheet.
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office