From: adodson on
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.
From: Luke M on
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" <adodson(a)discussions.microsoft.com> wrote in message
news:F7C768FE-2ED0-4FB4-881E-CDC9C7CE75DB(a)microsoft.com...
> 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.