[TABLE="width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Department[/TD]
[TD]Wages[/TD]
[TD]401K[/TD]
[/TR]
[TR]
[TD]Smith, John[/TD]
[TD]Admin[/TD]
[TD]10,000[/TD]
[TD]200[/TD]
[/TR]
[TR]
[TD]Lavine, Avril[/TD]
[TD]Sales[/TD]
[TD]500[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]Turner, Ted[/TD]
[TD]Admin[/TD]
[TD]100[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]Fonda, Jane[/TD]
[TD]Sales[/TD]
[TD]750[/TD]
[TD]75[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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.
<tbody>[TR]
[TD]Name[/TD]
[TD]Department[/TD]
[TD]Wages[/TD]
[TD]401K[/TD]
[/TR]
[TR]
[TD]Smith, John[/TD]
[TD]Admin[/TD]
[TD]10,000[/TD]
[TD]200[/TD]
[/TR]
[TR]
[TD]Lavine, Avril[/TD]
[TD]Sales[/TD]
[TD]500[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]Turner, Ted[/TD]
[TD]Admin[/TD]
[TD]100[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]Fonda, Jane[/TD]
[TD]Sales[/TD]
[TD]750[/TD]
[TD]75[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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.