| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I count nonblank text cells in Excel | Excel Discussion (Misc queries) | |||
| Count no. of nonblank cells in one column based on criteria of ano | Excel Discussion (Misc queries) | |||
| count 2 nonblank cells on multiple worksheets | Excel Discussion (Misc queries) | |||
| How do I count nonblank cells in rows within Excel? | New Users to Excel | |||
| Count nonblank cells with multiple criteria | Excel Worksheet Functions | |||
Linear Mode
