Home |
Search |
Today's Posts |
#1
|
|||
|
|||
countif condition problem
I am working with two rows of data, I want to count the number of times that
both rows are equal to a value I specify. Something like this COUNTIF(1:1, AND(1:X="1", 2:X="0")). Given the table below, the formula should be equal to two. A B C D E F G H I J K 1 0 0 1 0 0 1 0 0 1 0 1 2 1 0 0 1 0 1 0 0 0 1 1 -- Scott Miller University of Washington Chemistry |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
countif problem | Excel Discussion (Misc queries) | |||
Excel Display Problem | Excel Discussion (Misc queries) | |||
Combining IF and COUNTIF based on two columns | Excel Discussion (Misc queries) | |||
Countif - Countif | Excel Worksheet Functions | |||
Countif Problem | Excel Worksheet Functions |