Getting the sum of multiple row if an identifier is matched?
Our take
So I have several sheets of data.
Sheet1:
Identifier
Sheet2:
Find the identifier within the row. I have hundreds of rows of data. If an identifier is in the first 3 values, I want to add the first column after the break, 10. If the identifier is in the second set of 3 values, I want to add the column after that, 100.
I want to add a column Sheet1 to contain the sum of that given identifier for my all my data rows. The data in the 6 columns will never have duplicates.
It would be something like this if I wanted to add a single row, but I want it to add all of my data rows.
=IF(COUNTIF(Sheet1!B1:D1, A2) > 0, Sheet1!L1, 0) + IF(COUNTIF(Sheet1!E1:G1, A2) > 0, Sheet1!M1, 0)
How do I find a single sum for a given identifier for multiple rows of data where I want to get the sum of a column if that identifier is in a different column?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience