sum column based on single cell match?

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.
 
L

Luke M

Something like this:

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

INDEX - MATCH - OFFSET By Reference 2
Sum Column Based on Cell Color 5
Sum cells using criteria from a row and a column 2
Excel ALERT a duplicate of the match of two cells in two different columns... please 0
Match and Sum? 2
Sum column based on text of another 2
Sum Column above current cell dynamically using function call 7
looking up cell address 1

Top