...lookup?

[J.W. Aldridge]

Names are in cell e10, j10, o10, t10, y10, ad10.
Numbers are in: G11, L11, Q11, V11,AA11, AF11...

How do i perform a lookup for the name reference in the top row to sum
the values in the bottom row?

In other words, lookup value = x.
Lookup in range "funny" (rows 10 & 11).
Each time "x" is found, return and add the values in the cell down
1row ,2 over to the right.

 

[RagDyer]

Say you enter your name to find into D10, and try this:

=SUMPRODUCT((MOD(COLUMN(E10:AD10),5)=0)*(E10:AD10=D10)*(MOD(COLUMN(G11:AF11)-2,5)=0)*G11:AF11)

 

[Don Guillett]

If desired, send your file to my address below along with this msg and
a clear explanation of what you want and before/after examples.

 

[RagDyer]

Try this, with name to lookup entered into say D10:

=SUMPRODUCT((MOD(COLUMN(E10:AD10),5)=0)*(E10:AD10=D10)*(MOD(COLUMN(G11:AF11)-2,5)=0)*G11:AF11)