Apparently you've figured it out, but for others, let me explain the
DSUM function, how it can be used to solve your problem, and some
information related to finding further information about Excel
First, DSUM takes three parameters:
o database - the range of cells holding the "data". The first row has
the labels for each column.
o field - the column label (as text) or column number with the data
value to extract
o criteria - the range of cells indicating the values to perform the
selection. The first row of each column has a label (to match the
labels in the database) and the second row has a value to match. All
columns must match the corresponding items in a row for the values in
the "field" column to be summed.
The example I used was
where the sample data was in cells A1:D10, the third column was the
quantity column, and cells F1:G2 were the criteria I used.
As an alternative, you can also use
where I stored the text "Quantity" in cell F7 to refer to the same
column as described above.
Using Excel help, a search with a function name such as
will bring up a direct reference to the function definition along with
some related pages of information. For information stored in a
"database", the search phrase
will provide a link to DSUM as well as a number of other related
database functions and informational pages.
Searching online (with a search engine like Google), extend the phrase
to something like
dsum excel example
to find informational pages such as
which starts with a SUMIF example and includes DSUM as one of a few
alternatives with good examples and spreadsheets to download.
If any part of the answer is unclear or you need further information,
please make a clarification request. I would be glad to answer
Good luck with your work.