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
|
|||
|
|||
Help with IF - THEN
Hi - need formula that will count in one column based on condition in another
column. For Instance - if column A has "Blue" , I want to check column B and if it has "Y" I want to count the number of "Y"'s (associated with Blue) Thanks for your help in advance. ct |
#2
|
|||
|
|||
Help with IF - THEN
=SUMPRODUCT(--(A2:A200="Blue"),--(B2:B200="Y"))
-- __________________________________ HTH Bob "Cindyt" wrote in message ... Hi - need formula that will count in one column based on condition in another column. For Instance - if column A has "Blue" , I want to check column B and if it has "Y" I want to count the number of "Y"'s (associated with Blue) Thanks for your help in advance. ct |
#3
|
|||
|
|||
Help with IF - THEN
When you have multiple criteria use SUMPRODUCT()
=SUMPRODUCT((A1:A10=criteria1)*(B1:B10=criteria2)) =SUMPRODUCT((A1:A10=F1)*(B1:B10=F2)) If this post helps click Yes --------------- Jacob Skaria "Cindyt" wrote: Hi - need formula that will count in one column based on condition in another column. For Instance - if column A has "Blue" , I want to check column B and if it has "Y" I want to count the number of "Y"'s (associated with Blue) Thanks for your help in advance. ct |
#4
|
|||
|
|||
Help with IF - THEN
Hi,
Maybe this =SUMPRODUCT((A1:A19="Blue")*(B1:B19="Y")) Mike "Cindyt" wrote: Hi - need formula that will count in one column based on condition in another column. For Instance - if column A has "Blue" , I want to check column B and if it has "Y" I want to count the number of "Y"'s (associated with Blue) Thanks for your help in advance. ct |
#5
|
|||
|
|||
Help with IF - THEN
Ahh, the ever popular SUMPRODUCT!
=SUMPRODUCT((A2:A5000="Blue")*(B2:B5000="Y")) Please note, cannot use entire column (A:A), and both ranges must match (2-5000, or 2 - 100, or whatever) "Cindyt" wrote: Hi - need formula that will count in one column based on condition in another column. For Instance - if column A has "Blue" , I want to check column B and if it has "Y" I want to count the number of "Y"'s (associated with Blue) Thanks for your help in advance. ct |
#6
|
|||
|
|||
Help with IF - THEN
If you're using Excel 2007:
=COUNTIFS(A1:A100,"Blue",B1:B100,"Y") Better to use cells to hold the criteria: D1 = Blue E1 = Y =COUNTIFS(A1:A100,D1,B1:B100,E1) -- Biff Microsoft Excel MVP "Cindyt" wrote in message ... Hi - need formula that will count in one column based on condition in another column. For Instance - if column A has "Blue" , I want to check column B and if it has "Y" I want to count the number of "Y"'s (associated with Blue) Thanks for your help in advance. ct |
Thread Tools | |
Display Modes | |
|
|