Thanks to both of you but i am struggling here. I have never made a macro before and can't get it to work, Any advice on how to make it right? i don't know what i am doing wrong...i have a mac power book & excel 2004. Just in case of any misunderstanding, I need the macro to count cells with values > 0 not to sum the values.

Regards