Sumifs with multiple criteria and cross-sheet referencing

Michelle Basson

Good day,

I am struggling to get the formula for sumifs.

I have used both options below but it does not work.

SUMIFS({Description} = Description2_{Stock Request} > 0; [{Sub-warehouse}; "Brandon"])

SUMIFS({Description} = Description2; {Stock Request} > 0; {Sub-warehouse}; "Brandon")

I need the quantity to be summed if the Description in the sheet A corresponds with the Description in sheet B, the sub warehouse should be assigned to Brandon and it should then add up the totals for that specific product and give the total in sheet B where it currently says #unparseable

I am clearly missing something here. I have tried various versions of this formula.

Think it might be the late nights. 🤪

Regards

M

Paul Newcome

Try something like this...

=SUMIFS({Range to Sum}, {Description}, Description@row, {Sub-warehouse}, "Brandon")

Paul Newcome

Try something like this...

=SUMIFS({Range to Sum}, {Description}, Description@row, {Sub-warehouse}, "Brandon")

Michelle Basson

Hi Paul,

Brilliant. Thanks so much. it works perfectly now.

Have a great day.

M

Paul Newcome

Happy to help. 👍️

Michelle Basson

@Paul Newcome If I wanted to add an additional criteria how would I go about that.

I have added a column to sheet A stating whether the item is serialized or not (as in sheet 2 column 3)

I then want to split the cumulative totals into 2 columns, one for Serialized items, and one for non-serialized items. I need a formula to only take in all the products where the Sub warehouse is eg. Brandon, the product is the same and the product is yes for serialized.

So the below formula but with and add on the take into account whether it is Yes in the serialized column.

=SUMIFS({Range to Sum}, {Description}, Description@row, {Sub-warehouse}, "Brandon")

Hope this makes sense.

Kindest regards

M 😀

Paul Newcome

You would continue with the pattern of

", range, criteria, range, criteria, ....................."