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