"jtoy" wrote...
Similar to this formula, I now need to be able to sum values in the same
row. Using the example I posted earlier above, instead of returning the
value 4 from column C, I need to be able to add up the values in column
C, D, E and F.
....
"Peo Sjoblom" wrote:
=INDEX(C1:C100,MATCH("Jason",A1:A100,0)+1)

If this INDEX(..,MATCH(..)) formula works for looking up the column C value
you want, then either

=INDEX(C1:C100,MATCH("Jason",A1:A100,0)+1)
+INDEX(D1:D100,MATCH("Jason",A1:A100,0)+1)
+INDEX(E1:E100,MATCH("Jason",A1:A100,0)+1)
+INDEX(F1:F100,MATCH("Jason",A1:A100,0)+1)

or

=SUMPRODUCT((MATCH("Jason",A1:A100,0)+1=ROW(A1:A10 0))*C2:F101)