CODEWITHSUNDEEP
excelexcel-formula
Rox
Rox

Reputation: 13

Excel: how to sum values in sheet2 based on whether a value in sheet1 matches value in sheet2

Here is the formula I have written that isn't working:

=SUMIF(Sheet2!E:E,"E2",Sheet2!T:T)

Sheet1 contains a list of person identifiers (column E).
Sheet2 contains rows that contain these identifiers and balances.
One individual identifier (column E) will be in multiple rows with a variety of balances (column T).

I want to pull the sum of an identifier's balances into Sheet1.

Upvotes: 1

Views: 171

Answers (1)

CallumDA
CallumDA

Reputation: 12113

A couple of things to change:

  1. You say that your identifier column (E) is in Sheet1, but in the formula you've referenced Sheet2
  2. To reference a value in a cell use E2 rather than 'E2'. I.e. no apostrophes

So hopefully this works now:

=SUMIF(Sheet1!E:E,E2,Sheet2!T:T)

Upvotes: 1

Related Questions