View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
martinbarnes martinbarnes is offline
external usenet poster
 
Posts: 21
Default DCOUNT or nested functions?

The help page for the DCOUNT function is a little confusing. I am trying to
count the number of cells that meet criteria in 2 different columns. For
example, I have a column of cars by model and a column with the month and
year the cars were purchased. I want a count of each model bought during a
specific month/year. Is there another way to do this (i.e. nest the COUNTIF
function) besides DCOUNT?

any help would be appreciated...