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