I'm brand new to using Excel and I am trying to summarize an inventory from a rather large source sheet. On the summary sheet, I used =UNIQUE(INVENTORY!B8:B47) to tell me all of the things we carry, and =SUMIF(INVENTORY!B8:B47, SUMMARY!B8#, INVENTORY!D8:D47) to display how many we have in stock. It's important to know how many we have of each color so I'm trying to find a way to list that. Preferrably the output of this function would just be a list of the colors we have and how many of that color we have in stock for each unique item we have. Everything we have comes in different colors so I'd hate to list them all and use the count function in the basic way that I know how. I've tried a few things but, obviously, none of them work!