Calculating amounts with criteria across sheets

[rheriksen]

Hi,

I have a workbook, which is used to record a cooking school's daily use of food.
We are located in another company, whereby our ingredients can come from the another part of the company or ordered directly for the school.
I mark with an X in B4 which ingredients come from the other department, in order to properly account for the ingredients.

We would like to put in a calculation sheet, which only sums the ingredients coming from the other department, all the ones marked with X.
It looks like this:
Daily_Budget_Clean.xlsx

SUMIF is not a solution and searching have rendered me clueless to a solution so far.
Is there an easy way to calculate the ingredients with X from the others, so the accountant can easily have an overview of where the ingredients have come from?

[Glenn Kennedy]

It is unlikely that anyone will wish to replicate your spreadsheet themselves before starting on this. Please post a sample spreadsheet, not a series of screenshots.

[Glenn Kennedy]

If you wanted to see where the Xs are, see sheet 1. If (as I think moree likely) you want to see the amounts corresponding to the X'd items, see sheet 2.

If this isn't what you want, please shout...

[rheriksen]

Hi Glenn,

It was exactly what I had been looking for.
Thank you very much for your answer and your help.