Spring Heeled Jim
New Member
- Joined
- Aug 1, 2017
- Messages
- 1
Hello
Could anyone tell me how I go about determining in Excel 2010 if a person named in Col A has any one of the Category Columns checked. I don't need to know if they've got more than one ie Mick has three checked. That's not important to what Im trying to achieve. I'm thinking its some kind of sumifs or countifs but its beyond me at the moment. Thanks for you advice and help.
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Cat A[/TD]
[TD]Cat B[/TD]
[TD]Cat C[/TD]
[TD]Cat D[/TD]
[TD]Cat E[/TD]
[/TR]
[TR]
[TD]Mick
[/TD]
[TD][/TD]
[TD]CHECKED[/TD]
[TD]CHECKED[/TD]
[TD][/TD]
[TD]CHECKED[/TD]
[/TR]
[TR]
[TD]Simon[/TD]
[TD][/TD]
[TD][/TD]
[TD]CHECKED[/TD]
[TD]CHECKED[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Sarah[/TD]
[TD][/TD]
[TD][/TD]
[TD]CHECKED[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Neil[/TD]
[TD]CHECKED[/TD]
[TD][/TD]
[TD]CHECKED[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Dawn[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]CHECKED[/TD]
[/TR]
</tbody>[/TABLE]
Could anyone tell me how I go about determining in Excel 2010 if a person named in Col A has any one of the Category Columns checked. I don't need to know if they've got more than one ie Mick has three checked. That's not important to what Im trying to achieve. I'm thinking its some kind of sumifs or countifs but its beyond me at the moment. Thanks for you advice and help.
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Cat A[/TD]
[TD]Cat B[/TD]
[TD]Cat C[/TD]
[TD]Cat D[/TD]
[TD]Cat E[/TD]
[/TR]
[TR]
[TD]Mick
[/TD]
[TD][/TD]
[TD]CHECKED[/TD]
[TD]CHECKED[/TD]
[TD][/TD]
[TD]CHECKED[/TD]
[/TR]
[TR]
[TD]Simon[/TD]
[TD][/TD]
[TD][/TD]
[TD]CHECKED[/TD]
[TD]CHECKED[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Sarah[/TD]
[TD][/TD]
[TD][/TD]
[TD]CHECKED[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Neil[/TD]
[TD]CHECKED[/TD]
[TD][/TD]
[TD]CHECKED[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Dawn[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]CHECKED[/TD]
[/TR]
</tbody>[/TABLE]