keelaboosa
New Member
- Joined
- Apr 3, 2018
- Messages
- 35
I'm having a hard time with this, and I'd really appreciate some help.
I've got 8 compounds distributed across 4 containers. I need to see if there are any compounds for which the container is empty.
I can use =SUMPRODUCT(1/COUNTIFS(tbl[COMPOUND],tbl[COMPOUND])) to return number of distinct compounds, but I need to include a test for CONTAINER VOLUME too.
In the table below, compound F is the only distinct compound with a container volume of zero - I should get a count of 1. How would I write this formula?
<tbody>
</tbody>
I've got 8 compounds distributed across 4 containers. I need to see if there are any compounds for which the container is empty.
I can use =SUMPRODUCT(1/COUNTIFS(tbl[COMPOUND],tbl[COMPOUND])) to return number of distinct compounds, but I need to include a test for CONTAINER VOLUME too.
In the table below, compound F is the only distinct compound with a container volume of zero - I should get a count of 1. How would I write this formula?
COMPOUND | CONTAINER VOLUME |
A | 40 |
B | |
C | |
D | |
E | |
F | |
A | 135 |
B | 135 |
C | 135 |
D | 135 |
E | 135 |
G | 135 |
A | 100 |
H | 100 |
D | 100 |
E | 100 |
<tbody>
</tbody>