Count nonblank cells based on another column
 

Column C has months listed (as text: Jan 2009) and Columns D-N have various
reference categories. Each row is marked at least once in Columns D-N with an
"X."

What I want to do is count the non-blank cells based on the month. For
example, for all of the Rows that have "Jan 2009" listed in Column C, I want
to count all the non blank cells in Column D (labeled "Letter").

I've tried COUNTIF, DCOUNTA, and SUMPRODUCT and feel like I keep missing
something.

Thanks!

Count nonblank cells based on another column
 

SUMPRODUCT should work.

=SUMPRODUCT(--(C1:C10="Jan 2009"),--(D1:D10<""))

HTH
Elkar


"SandyB" wrote:

Column C has months listed (as text: Jan 2009) and Columns D-N have various
reference categories. Each row is marked at least once in Columns D-N with an
"X."

What I want to do is count the non-blank cells based on the month. For
example, for all of the Rows that have "Jan 2009" listed in Column C, I want
to count all the non blank cells in Column D (labeled "Letter").

I've tried COUNTIF, DCOUNTA, and SUMPRODUCT and feel like I keep missing
something.

Thanks!