Count from Blank & Non-Blank Cells

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
 
S

Stefi

You are welcome! Thanks for the feedback!
Stefi

„Mandeep Dhami†ezt írta:
 
D

Dave Peterson

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto Filter - how to collapse "non-blank" cells in a column? 2
Need Array Formula for Counting Blank & Non Blank Cells (Multiple Criteria) 1
Deleting blank cells globally 8
count non blank cells with criteria 5
Count with merged cells 2
count non blank cells with condition 13
advanced filter for blanks 1
Count of visible, non-blank cells only? 8

Top