Count nonblank cells based on another column

[SandyB]

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!

 

[Elkar]

SUMPRODUCT should work.

=SUMPRODUCT(--(C1:C10="Jan 2009"),--(D110<>""))

HTH
Elkar