Perhaps this 'hint' will give you a start, this assumes values in rows 1
through 4, change as required. It gives the total of all "Potato" entries in
the range (word in D, quantity in C)
=SUMPRODUCT(--(D1:D4="Potato"),C1:C4)

there is almost always some help to be had at
HelpFrom @ jlathamsite.com
remove those spaces - if you really want help.

" wrote:

What I need is to be able to add the units of each product seperately
in the Summary sheet, and get percentages. Essentially I need to be
able to tell the Summary sheet the following: If any cell Column D in
the Order List Sheet = Potatos (or cookies, coffee, meat..etc), then
add the number in Column C in the corresponding cell to the "running
total". Note: Column D cells are a dropdown list (of various products)
tied to the Summary page

I have a sample spreadsheet I can show if it would help.

ANY HELP would be GREATLY APPRECIATED.....as I have been working on
this for over a week (off and on)