Sum a column when a certain cell = another cell
 

For example,

I have a table of data and I want to look in a certain row, find a certain
label and then sum anything that comes underneath that.

eg.
A
Sales Team Appraisal Check Trade Check Retail Check 12k
0 0 59
234 0 0
0 18 44
226 0 0
0 46 169
5 0 0

I need the formula to find "Sales Team" and add any data in that column.

Sum a column when a certain cell = another cell
 

Column headers in the range A1:E1
Data in the range A2:E10

=SUM(INDEX(A2:E10,,MATCH("sales Team",A1:E1,0)))

Or, use a cell to hold the criteria:

G1 = Sales Team

=SUM(INDEX(A2:E10,,MATCH(G1,A1:E1,0)))


--
Biff
Microsoft Excel MVP


"Antoinette" wrote in message
...
For example,

I have a table of data and I want to look in a certain row, find a certain
label and then sum anything that comes underneath that.

eg.
A
Sales Team Appraisal Check Trade Check Retail Check 12k
0 0 59
234 0 0
0 18 44
226 0 0
0 46 169
5 0 0

I need the formula to find "Sales Team" and add any data in that column.