Summing values in ONE column using VLOOKUP

[Hola_mr_excel]

Hi all revered Excel gods,

I have a question.

I have a sheet with payments from several vendors throughout the year, and some vendors have paid multiple times throughut the year.

I'm trying to use VLOOKUP to return the SUM of these payments from the same column - so essentially return values based on a reference value, but if the value appears twice it sums these two, and if it only appears once it returns only that one value. Am I making sense?

I only seem to find resources on how to sum values from MULTIPLE columns.

THanks in advance to all of you kind souls,

Best,
Scott

[AliGW]

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook.

Which version of Excel are you using? Please update your profile with either 2019 or 365 as appropriate.

[Hola_mr_excel]

Hey! Thanks for swift response. Done, dataset uploaded and profile update.

THanks!

[Fluff13]

How about

Please Login or Register  to view this content.

[rio.south]

why not use simple sumif instead of vlookup and sum??????

=SUMIF(payments!$A$2:$A$39, A2, payments!$B$2:$B$39).

[Hola_mr_excel]

Ah sweeet two responses!

Unfortunately your suggestions do not work. I want it to return the single value (from the paid USD columns in 'payments' column) if it occurs once (based on the reference value 'vendor number') and if the reference value occurs twice it sums the amount paid.

:

[Fluff13]

Which is exactly what both formulae do. Did you actually try them?

[Hola_mr_excel]

Yup, I did but I didn't get it to work. I just ended up getting a bunch of '0's. Attached (hoping I've made a newbie mistake)

I'm sorry I'm not the most adept at Excel!

Thanks again! really appreciate it

[rio.south]

That is what both responses are for. Either option will give you the same result.

[AliGW]

You need the formula in an adjacent column (to the right of the values in B). You have tried to overwrite the values!

[rio.south]

Just use sumifs add one s mean sumifs and you are good to go.

[Fluff13]

The formula you have used should be SUMIFS not SUMIF

[AliGW]

Yup! I didn't realise that the values are on the other sheet. Doh!!!

[Hola_mr_excel]

It works! You guys are brilliant, thank you so so much for being EXCEL-men-at-arms (and women) !!

Much appreciated!

[Fluff13]

You're welcome & thanks for the feedback.

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.