sumif maybe?

[Spring Heeled Jim]

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.

	Cat A	Cat B	Cat C	Cat D	Cat E
Mick		CHECKED	CHECKED		CHECKED
Simon			CHECKED	CHECKED
Sarah			CHECKED
Neil	CHECKED		CHECKED
Dawn					CHECKED

<tbody>
</tbody>

 

[Molden]

Presuming name is in Col A, Cat A is in B and so on

in cell F3 put =COUNTIF($B$3:$E$3,"Checked") for the number of "CHECKED" or =IF(COUNTIF($B$3:$E$3,"Checked")>0,"Yes","No") for a Yes or No if 1 or more is checked