| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIF with 2 columns
Hi, how do I count cells in A with nothing in B.
A B x x 2011/02/17 2011/03/21 x x 2011/04/11 x =COUNTIF(A:A;"x") but not counting when date (B:B) is available (it means it did arrive) Best regards, Alberto |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
COUNTIF with 2 columns
On Apr 11, 2:28*pm, "J.A.1975" wrote:
Hi, how do I count cells in A with nothing in B. [....] =COUNTIF(A:A;"x") but not counting when date (B:B) is available (it means it did arrive) =SUMPRODUCT((A1:A100="x")*(ISNUMBER(B1:B100)=FALSE )) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
COUNTIF with 2 columns
On 11 abr, 18:15, joeu2004 wrote:
On Apr 11, 2:28*pm, "J.A.1975" wrote: Hi, how do I count cells in A with nothing in B. [....] =COUNTIF(A:A;"x") but not counting when date (B:B) is available (it means it did arrive) =SUMPRODUCT((A1:A100="x")*(ISNUMBER(B1:B100)=FALSE )) Gracias joeu2004 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Countif using two columns? | Excel Discussion (Misc queries) | |||
| CountIf 2 columns | Excel Discussion (Misc queries) | |||
| COUNTIF - across 2 columns | Excel Worksheet Functions | |||
| Countif for 2 columns | Excel Worksheet Functions | |||
| countif in 2 columns | Excel Discussion (Misc queries) | |||
Hybrid Mode
