IF statement for multiple cells refrencing one cell

Okay,
So I don't really know how to title my situation but I need to get some help to solve it. I tried implementing the function that was posted on the
"IF statement for multiple cells" thread, but I could not get to work in my situation.
I am currently making some spreadsheets/forms for the guys at work to fill out so we can keep track of our current inventory by putting in the amounts used and wasted during the day. What I want to do is use a statement or function that will take the amount from the "cases" made cells in the Used sheet and send it over to the correct "Used" cell in the OrganicP sheet... I am trying to use the item number as a reference.
The IF statement that I tried was: =IF(Used!G8 = C5,Used!K8*6," ")
I figured that if I used =IF(Used!G7:G59=C5,Used!K7:K59*6," ") I could make it work, but unfortunately it does not work that way.
Is is possible to do something like this in Excel?

And sorry if this seems like a dumb situation but I am farely new to working with Excel.
Pouch Inventory.xlsx

Thank you so much Ace_XL!!! SUMIF worked perfect.

Originally Posted by ProSpiderman

Okay,
So I don't really know how to title my situation but I need to get some help to solve it. I tried implementing the function that was posted on the
"IF statement for multiple cells" thread, but I could not get to work in my situation.
I am currently making some spreadsheets/forms for the guys at work to fill out so we can keep track of our current inventory by putting in the amounts used and wasted during the day. What I want to do is use a statement or function that will take the amount from the "cases" made cells in the Used sheet and send it over to the correct "Used" cell in the OrganicP sheet... I am trying to use the item number as a reference.
The IF statement that I tried was: =IF(Used!G8 = C5,Used!K8*6," ")
I figured that if I used =IF(Used!G7:G59=C5,Used!K7:K59*6," ") I could make it work, but unfortunately it does not work that way.
Is is possible to do something like this in Excel?


And sorry if this seems like a dumb situation but I am farely new to working with Excel.
Attachment 197244

Hi do you remember this spreadsheet that is quoted above ? Well I liked the way you had the color done. Plz tell me you did that with conditional formatting. And if so, can you show me the way ---- ? How do get the coloring and the borders and all with excel statements. I just know you did not do that by hand !!!! thanks much

Thank you so much I will be aware .
Newbie to the system ! How do you marked solved for an issue ?