Hello,
I am building a tab [results]; on this tab, I have a column [column A] which lists a unique value (description). In [column B]; I need to create a formula. This formula needs to look into the [raw data] tab, and count the number of distinct IDs which share the same (description) and also have one more criteria with color = "red".
<tbody>
</tbody>
<tbody>
</tbody>
So basically, I want to look up [results].A2 in [raw data].C:C, make sure we are only looking at the "red" values in [raw data].B:B; and then count the number of distinct IDs associated with those two criteria.
I am building a tab [results]; on this tab, I have a column [column A] which lists a unique value (description). In [column B]; I need to create a formula. This formula needs to look into the [raw data] tab, and count the number of distinct IDs which share the same (description) and also have one more criteria with color = "red".
[results] | A | B |
1 | description | test |
2 | Tiny Shoes | NEED FORMULA HERE; 1 |
3 | Small Shoes | 2 |
4 | Tiny Socks | 0 |
5 | Small Socks | 0 |
6 | Tiny Shirt | 1 |
7 | Small Shirt | 0 |
<tbody>
</tbody>
[raw data] | A | B | C | D |
1 | ID | Color | description | |
2 | aaa | red | Tiny Shoes | |
3 | aaa | red | Tiny Shoes | |
4 | aaa | blue | Tiny Shoes | |
5 | aaa | red | Small Shoes | |
6 | aaa | red | Tiny Shirt | |
7 | bbb | blue | Tiny Shirt | |
8 | bbb | blue | Tiny Shirt | |
9 | bbb | red | Small Shoes |
<tbody>
</tbody>
So basically, I want to look up [results].A2 in [raw data].C:C, make sure we are only looking at the "red" values in [raw data].B:B; and then count the number of distinct IDs associated with those two criteria.