Sum the totals of multiple items

I tried the consolidate formula, but I can't get the descriptions to show. I only get the Item number. Is there a way to show both the item number and the description.

Mission Accomplished!!!

I couldn't get the description to show automatically,so I just use vlookup to pull the value.


Thanks for all the help.