excelNewbie22
Well-known Member
- Joined
- Aug 4, 2021
- Messages
- 550
- Office Version
- 365
- Platform
- Windows
hi,
i'm trying to understand several points, what am i doing wrong?
was trying to count combination of numbers, of 2's and 3's,
i checked the results in several ways,
also with two very similar formulas
and
a:
get different results, why? what the difference between the two? bh11 and bi11
b:
why simple countif in bj11 return result of 2 instead of 1?
i get it see's result as partial, but then why bk11 return only 1 when is has in AW13 partial result as well?
marked the results in red
c:
how can i fix the formula to search the exact criteria with no partial results?
i'm trying to understand several points, what am i doing wrong?
was trying to count combination of numbers, of 2's and 3's,
i checked the results in several ways,
also with two very similar formulas
and
a:
get different results, why? what the difference between the two? bh11 and bi11
b:
why simple countif in bj11 return result of 2 instead of 1?
i get it see's result as partial, but then why bk11 return only 1 when is has in AW13 partial result as well?
marked the results in red
c:
how can i fix the formula to search the exact criteria with no partial results?
Cell Formulas | ||
---|---|---|
Range | Formula | |
Y11:Y17 | Y11 | =C11&"-"&E11 |
Z11:Z17 | Z11 | =C11&"-"&F11 |
AA11:AA17 | AA11 | =C11&"-"&G11 |
AB11:AB17 | AB11 | =C11&"-"&H11 |
AC11:AC17 | AC11 | =D11&"-"&F11 |
AD11:AD17 | AD11 | =D11&"-"&G11 |
AE11:AE17 | AE11 | =D11&"-"&H11 |
AF11:AF17 | AF11 | =E11&"-"&G11 |
AG11:AG17 | AG11 | =E11&"-"&H11 |
AH11:AH17 | AH11 | =F11&"-"&H11 |
AI11:AM17 | AI11 | =C11&"-"&D11 |
AN11:AN17 | AN11 | =C11&"-"&D11&"-"&E11 |
AO11:AO17 | AO11 | =C11&"-"&D11&"-"&F11 |
AP11:AP17 | AP11 | =C11&"-"&D11&"-"&G11 |
AQ11:AQ17 | AQ11 | =C11&"-"&D11&"-"&H11 |
AR11:AR17 | AR11 | =C11&"-"&E11&"-"&F11 |
AS11:AS17 | AS11 | =C11&"-"&E11&"-"&G11 |
AT11:AT17 | AT11 | =C11&"-"&E11&"-"&H11 |
AU11:AU17 | AU11 | =C11&"-"&F11&"-"&G11 |
AV11:AV17 | AV11 | =C11&"-"&F11&"-"&H11 |
AW11:AW17 | AW11 | =C11&"-"&G11&"-"&H11 |
AX11:AX17 | AX11 | =D11&"-"&E11&"-"&F11 |
AY11:AY17 | AY11 | =D11&"-"&E11&"-"&G11 |
AZ11:AZ17 | AZ11 | =D11&"-"&E11&"-"&H11 |
BA11:BA17 | BA11 | =D11&"-"&F11&"-"&G11 |
BB11:BB17 | BB11 | =D11&"-"&F11&"-"&H11 |
BC11:BC17 | BC11 | =D11&"-"&G11&"-"&H11 |
BD11:BD17 | BD11 | =E11&"-"&F11&"-"&G11 |
BE11:BE17 | BE11 | =E11&"-"&F11&"-"&H11 |
BF11:BF17 | BF11 | =E11&"-"&G11&"-"&H11 |
BG11:BG17 | BG11 | =F11&"-"&G11&"-"&H11 |
BH11:BH17 | BH11 | =SUM(COUNTIF(Y12:BG17,Y11:BG11)) |
BI11:BI17 | BI11 | =SUM(--(COUNTIF(Y12:BG17,Y11:BG11)>0)) |
BJ11 | BJ11 | =COUNTIF(Y12:BG17,AC11) |
BK11 | BK11 | =COUNTIF(Y12:BG17,AM11) |