Something like this:

=SUM(INDEX(A3:G94,,MATCH(3200,A2:G2,0))

In this example, you have columns A-G for your data.

--
Best Regards,

Luke M
"adodson" wrote in message
...
This seems so simple and yet the solution eludes me...

In row 2 I want Excel to match a cell's contents (ex: find 3200). Once
finding the column that matches, I want it to sum rows 3:94.

Thank you in advance for your assistance.