Lookup formula

[sallyb]

Hi, sorry this is probably pretty simple to work out but I'm very time poor at the moment and am only an eighth of the way through this project.
I need to calculate how much we owe each person.
Person in column A. Amounts owed to that person are in column D.

Thanks so much!

 

[sallyb]

Sorry just realised I didn't attach my spreadsheet and now I can't work out where/how I can do it!?

 

[atisyam]

Hi Sallyb

When you logged in, scroll down this page and find a message box titled Posting Permission

From there, you can see if you can post any attachments. Good luck

 

[RoryA]

We don’t allow attachments. Read this sticky thread: https://www.mrexcel.com/forum/about-board/508133-attachments.html

 

[JazzSP8]

Person in column A. Amounts owed to that person are in column D.

Sounds like you need to be looking in the direction of SUMIF

As we can't see your data I've just asked the formula to look in A1 and sum up the values based in column D

=SUMIF(A:A,A1,D:D)

Amend the A1 part of the formula to where the persons name will be you want to calculate the totals for.