Hi

in F2
=COUNTIF(B2:E2,"y")
and fill down
should give you what you're looking for
--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
wrote in message
oups.com...
ok table looks something like this...

Patient Num " Cancer " Asthma " Diabetes " COPD " 1 " 2 " 3 or more "
-----------------------------------------------------------------------------------------------------
1 y
2 y y
3 y y
4 y
5 y y y y


and I want


Patient Num " Cancer " Asthma " Diabetes " COPD " 1 " 2 " 3 or more "
-----------------------------------------------------------------------------------------------------
1 y 1

2 y y 2
3 y y 2
4 y 1

5 y y y y 4

and then i'll format it from there