Thread: DCOUNTA with multiple criteria
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default DCOUNTA with multiple criteria
--Using DCOUNTA
http://office.microsoft.com/en-us/ex...090501033.aspx
Specify your criterias in Row 2


--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.
Reply With QuoteReply With Quote