Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DCOUNTA WITH MULTIPLE FIELD CRITERIA
How can I create a statement that will take in consideration criterai
in two fields. For example, all rows where the last name is Smith, and the City is NYC. Thanks, galsaba |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DCOUNTA WITH MULTIPLE FIELD CRITERIA
Hi
One way With last name in column A and City in column B =SUMPRODUCT(--($A$1:$A$1000="Smith"),--($B$1:$B$1000="NYC")) Change ranges to suit. -- Regards Roger Govier "galsaba" wrote in message ups.com... How can I create a statement that will take in consideration criterai in two fields. For example, all rows where the last name is Smith, and the City is NYC. Thanks, galsaba |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DCOUNTA WITH MULTIPLE FIELD CRITERIA
Try this link:
http://www.cpearson.com/Newsletter/C...2007_10_08.htm which is Chip Pearsons newsletter all about Excel data functions. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DCOUNTA WITH MULTIPLE FIELD CRITERIA
One way
=DCOUNTA(Database,"City",F1:G2) Where in this case the criteria (F1:G2) looks like Last Name City Smith NYC Criteria that are on the same row means that you are using what is in fact AND functionality, on separate rows it is OR You can replace City in the formula with Last Name or any other header in your database -- Regards, Peo Sjoblom "galsaba" wrote in message ups.com... How can I create a statement that will take in consideration criterai in two fields. For example, all rows where the last name is Smith, and the City is NYC. Thanks, galsaba |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
DCOUNTA search in field for value | Excel Discussion (Misc queries) | |||
DCOUNTA Complex Criteria Question | Excel Worksheet Functions | |||
Criteria for DCOUNTA for date values | Excel Discussion (Misc queries) | |||
Specify DCOUNTA Criteria in the Formula | Excel Discussion (Misc queries) | |||
Sum Multiple Criteria or DcountA | Excel Worksheet Functions |