Hi There,
I'm a relative novice at Excel and I'm having trouble working out a formula.
I'm trying to count the unique numbers in ROW G (Sectors) if certain criteria are met in other cells. For example,
IF (1_hypothesis = 9) AND (1_for/against = D OR 1_for/against = CF) AND (1_thick/thin = Thick) AND (2_hypothesis = 9) AND (2_for/against = D OR 2_for/against = CF) AND (2_thick/thin = Thick), I want it to count the number of unique numbers in Sectors (Row G).
I've tried SUM (with FREQUENCY, MATCH) and I get mostly there, but it stops working when I add more criteria.
If anyone could provide me with the formula, that would be great.
Thanks so much!!
<tbody>
</tbody>
I'm a relative novice at Excel and I'm having trouble working out a formula.
I'm trying to count the unique numbers in ROW G (Sectors) if certain criteria are met in other cells. For example,
IF (1_hypothesis = 9) AND (1_for/against = D OR 1_for/against = CF) AND (1_thick/thin = Thick) AND (2_hypothesis = 9) AND (2_for/against = D OR 2_for/against = CF) AND (2_thick/thin = Thick), I want it to count the number of unique numbers in Sectors (Row G).
I've tried SUM (with FREQUENCY, MATCH) and I get mostly there, but it stops working when I add more criteria.
If anyone could provide me with the formula, that would be great.
Thanks so much!!
A | B | C | D | E | F | G | ||||||||||||
1 |
<colgroup><col></colgroup><tbody> </tbody> |
<colgroup><col style="text-align: center;"></colgroup><tbody> </tbody> |
<colgroup><col style="text-align: center;"></colgroup><tbody> </tbody> |
<colgroup><col style="text-align: center;"></colgroup><tbody> </tbody> |
<colgroup><col style="text-align: center;"></colgroup><tbody> </tbody> |
<colgroup><col style="text-align: center;"></colgroup><tbody> </tbody> |
<colgroup><col style="text-align: center;"></colgroup><tbody> </tbody> | |||||||||||
2 | 9 | D | Thin | 3 | O | Thin | 1 | |||||||||||
3 | 10 | D | Thin | 9 | CF | Thin | 1 | |||||||||||
4 | 9 | O | Thick | 1 | ||||||||||||||
5 | 3 | D | Thin | 9 | D | Thin | 2 | |||||||||||
6 | 9 | CF | Thick | 1 | ||||||||||||||
7 | 1 | D | Thick | 2 | D | Thick | 3 | |||||||||||
8 | 9 | D | Thick | 1 | ||||||||||||||
9 | 9 | D | Thick | 2 |
<tbody>
</tbody>