Name | Department | Wages | 401K |
Smith, John | Admin | 10,000 | 200 |
Lavine, Avril | Sales | 500 | 10 |
Turner, Ted | Admin | 100 | 10 |
Fonda, Jane | Sales | 750 | 75 |
<tbody>
</tbody>
I want to use an index match/sum if formula to sum the 401K column. The problem is that my data's columns maybe in a different order but the heading will always be the same. I know this is simple but I'm struggling.