| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
count non blank cells with criteria
I need to count non blank cells that match a condition.
For example i want to count number of entries in Column "B" for "ANTH 328" course. A B ANTH 328 PC ANTH 328 ANTH 328 PC I have tried DCOUNTA and combination of functions. Nothing is working. Help will be greatly appreciated. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
count non blank cells with criteria
Hi!
Try this: =SUMPRODUCT(--(A1:A20="ANTH 328"),--(B1:B20<"")) Biff "UT" wrote in message ... I need to count non blank cells that match a condition. For example i want to count number of entries in Column "B" for "ANTH 328" course. A B ANTH 328 PC ANTH 328 ANTH 328 PC I have tried DCOUNTA and combination of functions. Nothing is working. Help will be greatly appreciated. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
count non blank cells with criteria
Hi Biff,
The function dosent work. It counts the number of entries in Column A . So it gives me count of 3 in the example below. But it should actually show the count of 2 since there are only two entries that match "ANTH 328". Any other guesses? "Biff" wrote: Hi! Try this: =SUMPRODUCT(--(A1:A20="ANTH 328"),--(B1:B20<"")) Biff "UT" wrote in message ... I need to count non blank cells that match a condition. For example i want to count number of entries in Column "B" for "ANTH 328" course. A B ANTH 328 PC ANTH 328 ANTH 328 PC I have tried DCOUNTA and combination of functions. Nothing is working. Help will be greatly appreciated. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
count non blank cells with criteria
Hi!
Take a look at this screencap: http://img526.imageshack.us/img526/1241/sump0mi.jpg If you're getting a result of 3 based on your example then the "blank" cell is not blank. Is there a formula in the second column? There may be unseen characters like spaces. As you can see in the screencap the formula does return the correct result. Biff "UT" wrote in message ... Hi Biff, The function dosent work. It counts the number of entries in Column A . So it gives me count of 3 in the example below. But it should actually show the count of 2 since there are only two entries that match "ANTH 328". Any other guesses? "Biff" wrote: Hi! Try this: =SUMPRODUCT(--(A1:A20="ANTH 328"),--(B1:B20<"")) Biff "UT" wrote in message ... I need to count non blank cells that match a condition. For example i want to count number of entries in Column "B" for "ANTH 328" course. A B ANTH 328 PC ANTH 328 ANTH 328 PC I have tried DCOUNTA and combination of functions. Nothing is working. Help will be greatly appreciated. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
count non blank cells with criteria
Hi Biff,
The formula worked. Thanks a lot. "Biff" wrote: Hi! Take a look at this screencap: http://img526.imageshack.us/img526/1241/sump0mi.jpg If you're getting a result of 3 based on your example then the "blank" cell is not blank. Is there a formula in the second column? There may be unseen characters like spaces. As you can see in the screencap the formula does return the correct result. Biff "UT" wrote in message ... Hi Biff, The function dosent work. It counts the number of entries in Column A . So it gives me count of 3 in the example below. But it should actually show the count of 2 since there are only two entries that match "ANTH 328". Any other guesses? "Biff" wrote: Hi! Try this: =SUMPRODUCT(--(A1:A20="ANTH 328"),--(B1:B20<"")) Biff "UT" wrote in message ... I need to count non blank cells that match a condition. For example i want to count number of entries in Column "B" for "ANTH 328" course. A B ANTH 328 PC ANTH 328 ANTH 328 PC I have tried DCOUNTA and combination of functions. Nothing is working. Help will be greatly appreciated. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
count non blank cells with criteria
You're welcome. Thanks for the feedback!
Biff "UT" wrote in message ... Hi Biff, The formula worked. Thanks a lot. "Biff" wrote: Hi! Take a look at this screencap: http://img526.imageshack.us/img526/1241/sump0mi.jpg If you're getting a result of 3 based on your example then the "blank" cell is not blank. Is there a formula in the second column? There may be unseen characters like spaces. As you can see in the screencap the formula does return the correct result. Biff "UT" wrote in message ... Hi Biff, The function dosent work. It counts the number of entries in Column A . So it gives me count of 3 in the example below. But it should actually show the count of 2 since there are only two entries that match "ANTH 328". Any other guesses? "Biff" wrote: Hi! Try this: =SUMPRODUCT(--(A1:A20="ANTH 328"),--(B1:B20<"")) Biff "UT" wrote in message ... I need to count non blank cells that match a condition. For example i want to count number of entries in Column "B" for "ANTH 328" course. A B ANTH 328 PC ANTH 328 ANTH 328 PC I have tried DCOUNTA and combination of functions. Nothing is working. Help will be greatly appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Generating truly blank cells | Excel Worksheet Functions | |||
| enter numbers in blank cells | Excel Worksheet Functions | |||
| formula to count cells not blanK | Excel Worksheet Functions | |||
| Blank Cells in Pivot Tables | Excel Discussion (Misc queries) | |||
| SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions | |||
Linear Mode
