I have multiple columns with alot of data in them. I want to know how many i need of specific items. my table currently looks like this
<tbody>
</tbody>
The times appeared column is calculated using countifs but it only counts the instances that grey tray appears in week 1 or 2 or whatever. In my database next to each container type i have an amount needed of each one and i was wondering how i could count the amount needed based on the week and container not just the amount it appears.
Thank you
Week number | Container type | Times appeared |
1 | Grey Tray | 10 |
Black box | 5 |
<tbody>
</tbody>
The times appeared column is calculated using countifs but it only counts the instances that grey tray appears in week 1 or 2 or whatever. In my database next to each container type i have an amount needed of each one and i was wondering how i could count the amount needed based on the week and container not just the amount it appears.
Thank you