adrienne0914
Board Regular
- Joined
- Mar 22, 2018
- Messages
- 57
- Office Version
- 2016
- Platform
- Windows
Hi all,
I am trying to figure out the best formula for this problem. My workbook is more complicated, but in a nutshell here is what I'm trying to create a formula for:
Data Tab
<tbody>
</tbody>
Animals tab
<tbody>
</tbody>
Month tab
<tbody>
</tbody>
<tbody>
</tbody>
If animal=Y and month=Y, multiply COUNT by CM1, otherwise multiply COUNT by CM2. So for instance, both conditions are met by cat. So multiply 18*50.
I hope someone can help.
I am trying to figure out the best formula for this problem. My workbook is more complicated, but in a nutshell here is what I'm trying to create a formula for:
Data Tab
ANIMAL | COUNT |
Cats | 18 |
Dogs | 245 |
Rabbits | 17 |
<tbody>
</tbody>
Animals tab
Cats | Y |
Dogs | N |
Bears | Y |
<tbody>
</tbody>
Month tab
Jan | y |
Feb | Y |
Mar | N |
<tbody>
</tbody>
CM1 | CM2 | |
Cats | 50 | 75 |
Dogs | 42 | 18 |
Bears | 22 | 37 |
<tbody>
</tbody>
If animal=Y and month=Y, multiply COUNT by CM1, otherwise multiply COUNT by CM2. So for instance, both conditions are met by cat. So multiply 18*50.
I hope someone can help.