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
|