Count nonblank cells based on another column

S

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top