Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I Excel countif column a =? and column b = null ?
I am trying to count all the "Nissans" in column a where in the same row in
column b is blank without having to create additional columns, I am sure that there should be a way of creating a countif and statement but do not seem to be able to make it work. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I Excel countif column a =? and column b = null ?
=SUMPRODUCT((A1:A100="Nissan")*(B1:B100=""))
Jerry tiff wrote: I am trying to count all the "Nissans" in column a where in the same row in column b is blank without having to create additional columns, I am sure that there should be a way of creating a countif and statement but do not seem to be able to make it work. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel should provide an easy way to switch a column into a row, n. | Excel Discussion (Misc queries) | |||
Excel countif based on size of numbers in one column in Access | Excel Worksheet Functions | |||
Column A is Town, Column B is names. How can Excel add & tell how. | Charts and Charting in Excel | |||
How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) | |||
How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) |