Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Count with 2 conditions?
My data is in the following format
A B 1 2 1 0 2 0 I want to count how often there is a "1" in column A and a corresponding 2 (in the same row) in colum B Thanks |
#2
|
|||
|
|||
In Column C put a formula concantenating Col A and B... = A1 & B1
Copy this down your list In D1 put the formula... =COUNTIF(C:C,"12") HTH, Gary Brown "Lee" wrote in message ... My data is in the following format A B 1 2 1 0 2 0 I want to count how often there is a "1" in column A and a corresponding 2 (in the same row) in colum B Thanks |
#3
|
|||
|
|||
=SUMPRODUCT((A1:A3=1)*(B1:B3=2))
Vaya con Dios, Chuck, CABGx3 "Lee" wrote in message ... My data is in the following format A B 1 2 1 0 2 0 I want to count how often there is a "1" in column A and a corresponding 2 (in the same row) in colum B Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I count number of cels the matches 2 conditions ? | Excel Worksheet Functions | |||
Count with multiple conditions | Excel Worksheet Functions | |||
Count function in excel with different conditions | Excel Worksheet Functions | |||
Count If Formula for multiple conditions?? How To?? | Excel Worksheet Functions | |||
Count Based upon Multiple Conditions | Excel Worksheet Functions |