Excel other tab multiple line and column VLOOKUP SUM

user_2641576 0
Viewed 71

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?

vlookup excel
2 Answers

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.

user_76754370

You probably need to use INDEX not Vlookup

and then follow the example bellow

enter image description here

Check this post as well

user_58413820
Related