Stuck for working out which formula i need

[Tucker92]

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

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

 

[tyija1995]

Hey,

So you have a column between Container Type and Times Appeared that contains the amount needed (of the container type)?

Try:
=SUMPRODUCT((B2:B10="Grey Tray")*(C2:C10))

Where B2:B10 contains container types and C2:C10 contains the amount needed.

Change the ranges to see fit - if this is on the right lines it should work! Assuming amount needed is a scalar value e.g. 5

 

[Tucker92]

This is how my database looks. So on my other sheet i can count the amount of times during week 1 the grey tray appears and the same for week two but i cant take into account the separate number needs

Week No	Container Type	Number needed
1	Motor Box	1
1	Grey Tray	2
1	Grey Tray	1
1	Motor box	1
1	Grey Tray	3
1	Grey Tray	2

<tbody>
</tbody>

So i need to return a total need of the grey trays throughout the week. Can i sum the total grey trays based on two lookup values and get a total found

 

[Tucker92]

Thank you i have found a way to do it using SumIFs

Thank you for your help and sorry for not being very good at explaining my problem