CODEWITHSUNDEEP
excelvlookup
Matt
Matt

Reputation: 15061

Excel other tab multiple line and column VLOOKUP SUM

I have a two tabs (data) and (summary).

My data tab looks something like this (mine has more columns but this gives you an idea:

enter image description here

The column order repeats every 9 columns.

In my summary tab I want it split out and a SUM of the 8th of 9 column grouped by the 1st of 9 column.

Example output from the numbers above:

ALPHA   45
BETA    53
CHARLIE 45

I have tried doing a VLOOKUP but this just brings back a single value.

How can I do a VLOOKUP that sums all found?

Upvotes: 2

Views: 81

Answers (2)

Variatus
Variatus

Reputation: 14383

As a crude solution, SUMIF should do the job.

=SUMIF(A1:A7,"ALPHA",H1:H7) + SUMIF(A1:A7,"ALPHA",Q1:Q7) + SUMIF(A1:A7,"ALPHA",Z1:Z7)

If the total number of column groups isn't known you may need something more elaborate.

Upvotes: 2

Daut
Daut

Reputation: 2625

You probably need to use INDEX not Vlookup

and then follow the example bellow

enter image description here

Check this post as well

Upvotes: 1

Related Questions