Adding cells related to search criteria

In Column T, I would like to search for each team listed in Column S. The search field is K2:O743. When the search criteria is found I would then like to sum what is found in column L.

For instance Arkansas is found in cells K3, K145 and K215. Arkansas’ win totals are found in cells L3, L145 and L215.

So, I would like for the formula to find the Arkansas search criteria and then sum the 3 cells in column L and place it in cell T8 beside Arkansas.

Thank you in advance,

Greg

You can use this in cell T8 for Arkansas:

=SUMIFS(L:L,$K:$K,$S8)

and copy it across into U8:V8 if you also want the totals for Lost and Tied. You can also copy the 3 formulae up and down if you want to complete the table for the other teams.

Hope this helps.

Pete

This function works but there is also data in columns O, P, Q and R

Originally Posted by Pete_UK

You can use this in cell T8 for Arkansas:

=SUMIFS(L:L,$K:$K,$S8)

and copy it across into U8:V8 if you also want the totals for Lost and Tied. You can also copy the 3 formulae up and down if you want to complete the table for the other teams.

Hope this helps.

Pete

This function works but there is also data in columns O, P, Q and R