Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIF with or + and variables
I'm having a hard time figuring this one out My challenge is to count if column [i] is "A" or "B" and column [K] and [O] are "C" I'm trying to count all the ones in column [J] that meet the specific conditions. I tried an array but it didn't seem to take. Any hints are greatly appreciated. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIF with or + and variables
Try this€¦
=COUNTIF(I:I,"A")+COUNTIF(I:I,"B")+COUNTIF(K:K,"C" )+COUNTIF(O:O,"C") Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "Dancest˜†r" wrote: [i] I'm having a hard time figuring this one out My challenge is to count if column is "A" or "B" and column [K] and [O] are "C" I'm trying to count all the ones in column [J] that meet the specific conditions. I tried an array but it didn't seem to take. Any hints are greatly appreciated. . |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIF with or + and variables
In J1, use this formula, then fill down.
=IF(AND(OR(I1="A", I1="B"), K1="C", O1="C"), 1, 0) Cheers, Rob Dancest˜†r wrote:[i] I'm having a hard time figuring this one out My challenge is to count if column is "A" or "B" and column [K] and [O] are "C" I'm trying to count all the ones in column [J] that meet the specific conditions. I tried an array but it didn't seem to take. Any hints are greatly appreciated. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIF with or + and variables
No, because there were two "AND"s and one "OR" in the OPs request.
-- David Biddulph "Ms-Exl-Learner" wrote in message ...[i] Try this. =COUNTIF(I:I,"A")+COUNTIF(I:I,"B")+COUNTIF(K:K,"C" )+COUNTIF(O:O,"C") Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "Dancest?r" wrote: I'm having a hard time figuring this one out My challenge is to count if column is "A" or "B" and column [K] and [O] are "C" I'm trying to count all the ones in column [J] that meet the specific conditions. I tried an array but it didn't seem to take. Any hints are greatly appreciated. . |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIF with or + and variables
or to put it all in one formula:
=SUMPRODUCT((I1:I100="A")+( I1:I100="B"), --(K1:K100="C"), --(O1:O100="C")) -- David Biddulph "Rob van Gelder" wrote in message ...[i] In J1, use this formula, then fill down. =IF(AND(OR(I1="A", I1="B"), K1="C", O1="C"), 1, 0) Cheers, Rob Dancest?r wrote: I'm having a hard time figuring this one out My challenge is to count if column is "A" or "B" and column [K] and [O] are "C" I'm trying to count all the ones in column [J] that meet the specific conditions. I tried an array but it didn't seem to take. Any hints are greatly appreciated. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTIF with or + and variables
---If you are looking to have the count as 1 for each row in Col J then try
the below in cell J1 and copy down =IF(AND(OR(I1="A",I1="B"),K1="C",O1="C"),1,0) ---If you want the sum of the count you can use the below formula which will get the count for the rows 1 to 100 =SUMPRODUCT((I1:I100={"A","B"})*(K1:K100="C")*(O1: O100="C")) -- Jacob "Dancest˜†r" wrote: [i] I'm having a hard time figuring this one out My challenge is to count if column is "A" or "B" and column [K] and [O] are "C" I'm trying to count all the ones in column [J] that meet the specific conditions. I tried an array but it didn't seem to take. Any hints are greatly appreciated. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF with 2 variables. HOW??? | Excel Worksheet Functions | |||
countif two variables in two different columns | Excel Worksheet Functions | |||
Countif function with variables | Excel Worksheet Functions | |||
another thought on COUNTIF 2 VARIABLES ?? | Excel Worksheet Functions | |||
COUNTIF ON 2 VARIABLES ?? | Excel Worksheet Functions |