I have two tabs. One tab has a list of identifiers and value next to it. There are duplicate identifiers. I'm looking to populate the values into tab 2 but I want to add up the values and so that Tab 2 reflects one identifier and one total value. I typically used something along the lines of =SUM((Sheet2!E$11:E$214)*C9(Sheet2!J$11:J$214)) Where C9 starts the single list of identifiers on Tab 2.
This formula doesn't seem to work. I'm a little rusty. Can anyone help?
elliott,
Not quite clear on this, as you say Sheet 2 is where you want the totalled values, but the formula is looking at Sheet 2 for the data to sum up?
Assume the "identifiers" are in Col J of sheet 1, and the values in Col E in Sheet 1,, C9 is on sheet 2, and you want the total values in Col D of sheet 2.
Put this in D9 on sheet 2, and copy down:
=SUMIFS(Sheet1!E$11:E$214,Sheet1!J$11:J$214,C9)
(Add up all the values in Col E of sheet 1 where the number in Col J is the same as C9 in sheet 2)
Ochimus
Last edited by Ochimus; 06-22-2016 at 01:37 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks