Prev: Counting Merged Cells
Next: =INDEX(AF1:BD108,MATCH(Z3,AD2:AD361),AF:AR)
From: adodson on 9 Apr 2010 13:49
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 9 Apr 2010 14:15
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.


 | 
Pages: 1
Prev: Counting Merged Cells
Next: =INDEX(AF1:BD108,MATCH(Z3,AD2:AD361),AF:AR)