Hello all! It's my first post, so please be nice
I'm trying to create a "dashboard" which looks up a value (hlookup) in the top row of the data set and returns back a sum of its "scores" from the column to the right. I tried and failed at nesting hlookup, sumproduct, and wrapping them in an offset. Help please?
<colgroup><col width="62" span="7" style="width:47pt"> </colgroup><tbody>
</tbody>
I'm trying to create a "dashboard" which looks up a value (hlookup) in the top row of the data set and returns back a sum of its "scores" from the column to the right. I tried and failed at nesting hlookup, sumproduct, and wrapping them in an offset. Help please?
bob | score | mary | score | jean | score | |
q1 | xxx | 1 | xxx | 3 | xxx | 0 |
q2 | xxx | 2 | xxx | 3 | xxx | 0 |
q3 | xxx | 0 | xxx | 3 | xxx | 2 |
q4 | xxx | 7 | xxx | 1 | xxx | 3 |
dashboard | ||||||
q1+2 | q3+4 | |||||
bob | 3 | ? | ||||
mary | ? | 4 | ||||
jean | 0 | ? |
<colgroup><col width="62" span="7" style="width:47pt"> </colgroup><tbody>
</tbody>