| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filtering A and counting B
Hi!
This is my problem: I have a worksheet with only "x" (as a check mark) in cells. I have filtered column A in order to see only the blank cells of A. Now I need to count the check marks that still are visible in col B after the filtering of A. I've been checking previous questions here and trying its answers but I dont succeed. I've even tried SUBTOTAL function, so if still that is the answer, could anybody explain it to me in an easier language than in Excel's Help? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Filtering A and counting B
No filtering rquired:
=SUMPRODUCT(--(A1:A100=""),--(B1:B100="x")) will count A=blank and B="x" HTH "SAM" wrote: Hi! This is my problem: I have a worksheet with only "x" (as a check mark) in cells. I have filtered column A in order to see only the blank cells of A. Now I need to count the check marks that still are visible in col B after the filtering of A. I've been checking previous questions here and trying its answers but I dont succeed. I've even tried SUBTOTAL function, so if still that is the answer, could anybody explain it to me in an easier language than in Excel's Help? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Filtering A and counting B
It didn't work at the biginning, but the program itself said what it had to
be changed: the (,) for a (;). Thank you VERY MUCH for your help, Toppers! Sam "Toppers" wrote: No filtering rquired: =SUMPRODUCT(--(A1:A100=""),--(B1:B100="x")) will count A=blank and B="x" HTH "SAM" wrote: Hi! This is my problem: I have a worksheet with only "x" (as a check mark) in cells. I have filtered column A in order to see only the blank cells of A. Now I need to count the check marks that still are visible in col B after the filtering of A. I've been checking previous questions here and trying its answers but I dont succeed. I've even tried SUBTOTAL function, so if still that is the answer, could anybody explain it to me in an easier language than in Excel's Help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filtering | Excel Discussion (Misc queries) | |||
| Filtering | Excel Worksheet Functions | |||
| filtering | Excel Discussion (Misc queries) | |||
| Counting rows, then counting values. | Excel Discussion (Misc queries) | |||
| trouble filtering a list. Why isn't column filtering? | Excel Worksheet Functions | |||
Linear Mode
