Count from Blank & Non-Blank Cells
 

Hi All,

Count from Blank & Non-Blank Cells

I have a database in excel and want count of data in certain columns on the
basis of following conditions:

Condition 1: In cell A1 I want the results.

Condition 2: Filter column F and select Blanks cells.

Condition 3: Filter column H and select Blanks cells.

Condition 4: Filter column G and select NON Blanks cells.

Condition 5: Now I want count of non-blanks cells in Column G

Cheers,
Mandeep Dhami

Count from Blank & Non-Blank Cells
 

Try this formula in A1:
=SUMPRODUCT(--(F2:F65536=""),--(H2:H65536=""),--(G2:G65536<""))
You can't use references to whole columns like F:F in SUMPRODUCT!

Regards,
Stefi


€žMandeep Dhami€� ezt Ã*rta:

Hi All,

Count from Blank & Non-Blank Cells

I have a database in excel and want count of data in certain columns on the
basis of following conditions:

Condition 1: In cell A1 I want the results.

Condition 2: Filter column F and select Blanks cells.

Condition 3: Filter column H and select Blanks cells.

Condition 4: Filter column G and select NON Blanks cells.

Condition 5: Now I want count of non-blanks cells in Column G

Cheers,
Mandeep Dhami

Count from Blank & Non-Blank Cells
 

Thanks Stefi the formula works.

"Stefi" wrote:

Try this formula in A1:
=SUMPRODUCT(--(F2:F65536=""),--(H2:H65536=""),--(G2:G65536<""))
You can't use references to whole columns like F:F in SUMPRODUCT!

Regards,
Stefi


€žMandeep Dhami€� ezt Ã*rta:

Hi All,

Count from Blank & Non-Blank Cells

I have a database in excel and want count of data in certain columns on the
basis of following conditions:

Condition 1: In cell A1 I want the results.

Condition 2: Filter column F and select Blanks cells.

Condition 3: Filter column H and select Blanks cells.

Condition 4: Filter column G and select NON Blanks cells.

Condition 5: Now I want count of non-blanks cells in Column G

Cheers,
Mandeep Dhami

Count from Blank & Non-Blank Cells
 

You are welcome! Thanks for the feedback!
Stefi

€žMandeep Dhami€� ezt Ã*rta:

Thanks Stefi the formula works.

"Stefi" wrote:

Try this formula in A1:
=SUMPRODUCT(--(F2:F65536=""),--(H2:H65536=""),--(G2:G65536<""))
You can't use references to whole columns like F:F in SUMPRODUCT!

Regards,
Stefi


€žMandeep Dhami€� ezt Ã*rta:

Hi All,

Count from Blank & Non-Blank Cells

I have a database in excel and want count of data in certain columns on the
basis of following conditions:

Condition 1: In cell A1 I want the results.

Condition 2: Filter column F and select Blanks cells.

Condition 3: Filter column H and select Blanks cells.

Condition 4: Filter column G and select NON Blanks cells.

Condition 5: Now I want count of non-blanks cells in Column G

Cheers,
Mandeep Dhami

Count from Blank & Non-Blank Cells
 

In xl2007, you can use the whole column.

Stefi wrote:

Try this formula in A1:
=SUMPRODUCT(--(F2:F65536=""),--(H2:H65536=""),--(G2:G65536<""))
You can't use references to whole columns like F:F in SUMPRODUCT!

Regards,
Stefi

€žMandeep Dhami€� ezt Ã*rta:

Hi All,

Count from Blank & Non-Blank Cells

I have a database in excel and want count of data in certain columns on the
basis of following conditions:

Condition 1: In cell A1 I want the results.

Condition 2: Filter column F and select Blanks cells.

Condition 3: Filter column H and select Blanks cells.

Condition 4: Filter column G and select NON Blanks cells.

Condition 5: Now I want count of non-blanks cells in Column G

Cheers,
Mandeep Dhami

--

Dave Peterson