sum column based on single cell match?

  • Thread starter Thread starter adodson
  • Start date Start date
A

adodson

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.
 
Something like this:

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

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