Compare Qty's in different sheets

Jenn123

I have 2 sheets. One is Contract Requirements and one is Hardware Deliverables. I want to compare the Quantities on the Contract Requirements to the Quantities on the Hardware Deliverables.

For Example..

Contract Requirements list Qty 6 on one line

Hardware Deliverables lists, 1, 3, 2 on 3 lines

How do I sum the quantities in Hardware deliverables to compare to the contract requirement quantities?

Jenn123

They are all calculation type formulas, I will try INDEX/MATCH and VLOOKUP. Thanks for the suggestion

Louis1

Hi J,

Is this what you are after? In the example below I am adding rows in sheet 2 and bringing them in sheet 1 using SUM via referencing another sheet (sheet 2) column.

L.

Paul Newcome

I am leaning towards a SUMIFS. Are you able to provide some screenshots for reference?

Jenn123

I've been using SUMIFs and referencing the other sheet, then I ran into this error message. I have a lot of rows on my sheets. How do I do it differently so I don't get this message?

Smartsheet Image.png

Paul Newcome

There are a number of posts here in the community that have a lot of detail, but the general idea is that (when possible) you combine some of the columns you are referencing into a string, bring that string over as a single cross sheet reference, then parse the string out into multiple columns on the target sheet. I remember going through these steps on another thread not too long ago.

Do you have any that are just bringing across data such as INDEX/MATCH or VLOOKUP, or are they all calculation type formulas?

Jenn123

They are all calculation type formulas, I will try INDEX/MATCH and VLOOKUP. Thanks for the suggestion