Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count the non blank cells | Excel Worksheet Functions | |||
How to count blank cells (Rows) between Non-Blank cells in Col "A" | Excel Discussion (Misc queries) | |||
Help getting count of non-blank cells | Excel Discussion (Misc queries) | |||
Do Not count blank cells | Excel Discussion (Misc queries) | |||
COUNT ONLY CELLS THAT AREN'T BLANK | Excel Worksheet Functions |