IF Condition (Excel) - Join Multiple Columns

I need to tally the number of times a term appears.

Unfortunately, the terms were not well organized so a term may appear in more than one column - so I can't use just =If(A1="HEALTH",1,0) because "HEALTH" appears in multiple columns A, B, C etc.

I've tried nesting - =IF(A1="HEALTH",1,IF(B2="HEALTH",1,0)) - but haven't had much success there either.

Maybe my formula's wrong? Or should I look to a different condition in Excel and if so, which?

Thanks in advance for your help.

Cheers,

Sam