8 Replies Latest reply on Nov 6, 2018 9:54 PM by Deepak Rai

# Lookup a value in Column A that exists in Column B and return the sum of integers from Column C

Hi,

I have a table with the following 1 to 4 columns (below) and I want to create the 5th column "Epic Points".

Basically, "Epic Points" should return the sum of points (from "Story Points") assigned to all stories linked to the same epic ("Epic A" in this example).

Thank you all for your help!

 Summary Epic Link Epic Name Story Points Epic Points Story B Epic A 2 Story C Epic A 9 Epic A Epic A 11
• ###### 1. Re: Lookup a value in Column A that exists in Column B and return the sum of integers from Column C

Hi Andrea,

Peter

• ###### 2. Re: Lookup a value in Column A that exists in Column B and return the sum of integers from Column C

Hi Andrea,

Here it is:

Thanks

Deepak

If it Helps, Pl mark it helpful and Correct to Close Thread

• ###### 3. Re: Lookup a value in Column A that exists in Column B and return the sum of integers from Column C

Hi Deepak,

Thanks for that! For some reason this does not seem to work when I copy and paste it in my sheet. Let me give you the full table I'm working on (attached).

Also please note: Sometimes the epic name can be different between 'Summary' and 'Epic Name' so I would like the calculated filed to rely solely on 'Epic Name'.

• ###### 4. Re: Lookup a value in Column A that exists in Column B and return the sum of integers from Column C

Ok give me your actual data and expected result

• ###### 5. Re: Lookup a value in Column A that exists in Column B and return the sum of integers from Column C

Sorry, I cannot send attachment! Would this suffice?

• ###### 6. Re: Lookup a value in Column A that exists in Column B and return the sum of integers from Column C

this does not work.pl attach this data as excel

• ###### 7. Re: Lookup a value in Column A that exists in Column B and return the sum of integers from Column C

leave it I got your data.

• ###### 8. Re: Lookup a value in Column A that exists in Column B and return the sum of integers from Column C

I think this should work for you,Summary is irrelevant so I took it Off.

Thanks

Deepak

If it Helps, Pl Mark it Helpful and CORRECT to Close Thread