If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Coutnif
I need help with a countif statement. I have information like the following:
A B X 1 Y 1 X 2 X 0 I need to count how many times X in column A is greater than zero in column B. |
#2
|
|||
|
|||
Coutnif
Countif can handle only one condition. For multiple conditions, use
Sumproduct, as in: =sumproduct(--(a1:a5="X"),--(b1:b50)) Regards, Fred. "Matt" wrote in message ... I need help with a countif statement. I have information like the following: A B X 1 Y 1 X 2 X 0 I need to count how many times X in column A is greater than zero in column B. |
#3
|
|||
|
|||
Coutnif
=sumproduct(--($A$2:$A$100="X"),--($B$2:$B$1000))
"Matt" wrote: I need help with a countif statement. I have information like the following: A B X 1 Y 1 X 2 X 0 I need to count how many times X in column A is greater than zero in column B. |
#4
|
|||
|
|||
Coutnif
If you're using Excel 2007:
=COUNTIFS(A1:A4,"x",B1:B4,"0") -- Biff Microsoft Excel MVP "Matt" wrote in message ... I need help with a countif statement. I have information like the following: A B X 1 Y 1 X 2 X 0 I need to count how many times X in column A is greater than zero in column B. |
#5
|
|||
|
|||
Coutnif
Hi,
And here are two old school formulas: =SUMPRODUCT((A2:A5="X")*(B2:B50)) =SUM((A2:A5="X")*(B2:B50)) this one array entered (Shift+Ctrl+Enter) -- Thanks, Shane Devenshire "Matt" wrote: I need help with a countif statement. I have information like the following: A B X 1 Y 1 X 2 X 0 I need to count how many times X in column A is greater than zero in column B. |
Thread Tools | |
Display Modes | |
|
|