1

In my Excel file, I have two sheets. One is named Airjet and contains detailed data with numerous columns:

  • Column I lists all the months
  • column Z lists the yarn counts

I want to extract data into another sheet named Summary Sheet.

The goal is as follows: if the value in column I of Airjet matches with cell J3 of Summary Sheet, and the value in column Z of Airjet matches the value in cell H4 of Summary Sheet, then I want to calculate the sum of column AA in Airjet and store the value into cell J4 in Summary Sheet.

Improve this question

1 Answer 1

Reset to default
1

You can do this easily using a SUMIFS formula.
Here’s exactly what you should put in cell J4 of your Summary Sheet:

=SUMIFS(Airjet!AA:AA, Airjet!I:I, J3, Airjet!Z:Z, H4)

  • SUMIFS adds up all values in Airjet!AA:AA that meet multiple criteria.

  • The first condition: Airjet!I:I, J3 → matches the month in column I of Airjet with cell J3 in Summary Sheet.

  • The second condition: Airjet!Z:Z, H4 → matches the yarn count in column Z of Airjet with cell H4 in Summary Sheet.

  • The sum range: Airjet!AA:AA → specifies which column to sum.

Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

Thanks - it was very helpful and it really worked.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.