Count from Blank & Non-Blank Cells

  • Thread starter Thread starter Mandeep Dhami
  • Start date Start date
M

Mandeep Dhami

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
 
In xl2007, you can use the whole column.
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:
Click to expand...
 
Back
Top