Microsoft Office Tutorials and References
In Depth Information
Using AND to Join Criteria
Using
Using AND
AND to Join Criteria
to Join Criteria
Many people using SUMIF in Excel 2003 and earlier are likely to want to
know how to conditionally sum based on two conditions. This is simple to do
with DSUM. If two criteria are placed on the same row of the criteria range,
they are joined by an AND. In Figure 12.53 , for example, the $123,275 is the sum
of records where the customer is Best Paint Inc. and the product is V937.
Figure 12.53.
Figure 12.53. When two criteria are on the same line, they are joined by an
When two criteria are on the same line, they are joined by an
AND
AND function; rows must meet both criteria to be included in the
function; rows must meet both criteria to be included in the DSUM
DSUM..
Using
Using OOR to Join Criteria
to Join Criteria
When two criteria are placed on separate rows of the criteria range, they are
joined by an OR function. In Figure 12.54 , the $2.1 million represents records
for either Improved Radio Traders or Best Paint Inc.
Figure 12.54.
Figure 12.54. When two criteria are on different rows, they are joined by an
When two criteria are on different rows, they are joined by an
OOR function; rows can meet either criteria to be included in the
function; rows can meet either criteria to be included in the DSUM
DSUM..
Search JabSto ::




Custom Search