Sum Index Match

[trotm]

Hi,

I am trying to get the total from a list of expenses relating to a certain account code.

I have tried a vlookup but the data is right to left and it returns errors.

I am keen to learn now to use the Index / Match function to return the answer but can only get the first value in the list back.

The formula I have so far is:

=SUM(INDEX($E:$E,MATCH($A$6,$F:$F,0),0))

I'm having trouble attaching the file hope this image will be sufficient. Untitled.png

Thanks in advance.

[JohnTopley]

Attach a sample workbook.

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[trotm]

Please see attached file

[JohnTopley]

In B6 of "After"


=SUMIF(D:D,A6,E:E)

will sum for Account in A6 (HTL)

[trotm]

That works well.

Think I was over complicating things

Thank you.