DCOUNT or nested functions?

[martinbarnes]

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...

 

[Tom Hutchins]

You could use a SUMPRODUCT formula similar to this:
=SUMPRODUCT(--(A16:A19="Ford"),--(B16:B19=2005))

Here is a link to a great tutorial about SUMPRODUCT:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

Hope this helps,

Hutch

 

[martinbarnes]

Hutch,

Thanks a ton - that was perfect.

Marty

You could use a SUMPRODUCT formula similar to this:
=SUMPRODUCT(--(A16:A19="Ford"),--(B16:B19=2005))

Here is a link to a great tutorial about SUMPRODUCT:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

Hope this helps,

Hutch