If you know how many columns wide the data is, then it a SUM will work for you
Let's assume row 1 has column headings and the data starts in row 2. Your
example shows 1 column of names & 6 columns of data. How about this formula
=SUM(OFFSET(B1:G1,MATCH("Jack",A2:A6,0),0,1,6))
"Mark the Shark" wrote:
I've been trying to combine a vlookup function with a sumif function
for weeks now, however, without success.
This is my problem. Instead of looking up a single value, i.e.
=vlookup(A1, rang, 4, false), I like to do this for an entire range
and suming up that range. Something like this:
1 2 3 4 5 6
Table 1 10ぎ 35ぎ 50ぎ 23ぎ 60ぎ 50ぎ
Jack 10ぎ 35ぎ 50ぎ 23ぎ 60ぎ 50ぎ
Brian 10ぎ 35ぎ 50ぎ 23ぎ 60ぎ 50ぎ
Juergen 10ぎ 35ぎ 50ぎ 23ぎ 60ぎ 50ぎ
Feff 10ぎ 35ぎ 50ぎ 23ぎ 60ぎ 50ぎ
So, I like to look-up the sum of these value without suming up these
values in table 1 and doing a vlookup on the sum.
Table 2
Feff
Juergen
Jack
I think the formula should look something like
this...=(sum(if(vlookup(Table2'A1;range;1;false)=T able2'A1;sum(range)))...I
really have no idea how excel can choose the particular row to sum up
the value. I hope this is not too confusing to you. I figured I'd
write it in English rather than German as more user can help me out on
this. I really appreciate any help. thanks you!!!
|