| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
countif two variables in two different columns
I have column b and column c, I want to count if b=4 and c=1 but if b=4 and
c=2 I don't want it to count it. Can anyone tell me how this would be done? |
|
#2
|
|||
|
|||
|
=SUMPRODUCT(--(B1:B9999=4),--(C1:C9999=1))
"Greg Diamond" <Greg wrote in message ... I have column b and column c, I want to count if b=4 and c=1 but if b=4 and c=2 I don't want it to count it. Can anyone tell me how this would be done? |
|
#3
|
|||
|
|||
|
Use the following array formula (end with Ctrl+Shift+Ebter):
=COUNT(IF(((Sheet3!$B$12:$B$19)=4)*((Sheet3!$C$12: $C$19)=1),Sheet3!$B$12:$B$19)) ===== * ===== * ===== * ===== Daniel CHEN www.Geocities.com/UDQServices Free Data Processing Add-in< ===== * ===== * ===== * ===== "Greg Diamond" <Greg wrote in message ... I have column b and column c, I want to count if b=4 and c=1 but if b=4 and c=2 I don't want it to count it. Can anyone tell me how this would be done? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| analysing data from alternate columns using the countif function | Excel Discussion (Misc queries) | |||
| Combining IF and COUNTIF based on two columns | Excel Discussion (Misc queries) | |||
| want to count in two columns; countif (colA=x AND colB=y)? | Excel Worksheet Functions | |||
| How do I perform a "Countif" function for Two Columns? | Excel Worksheet Functions | |||
| Countif function with variables | Excel Worksheet Functions | |||
Linear Mode
