Skip to main content
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Help With Complex Excel Formula

I'm trying to figure out how to pull specific data from all worksheets in a workbook and total them all on a single total page.

What I have is multiple shopping/prep lists for my menus and each lists the amount of each item to buy and prep. If I have more than one event to shop for, I currently have to bring all lists to the store and look at each of them individually for similarities and then add them in my head.

Example: 3 events need carrots, each with different amounts. I have one column that lists items needed and a separate column that lists a number of pounds needed. I want to create a "totals" sheet that will find the word "carrots" in the workbook and then add the total pounds of carrots needed based on the "amount" cells across all sheets.