help with sum function

[xygrax]

Hello,

May I seek help about count function.

I would want to count the number of each columns collected by a given person. I just dont know the formula to get it. :'(

I have attached the sample data
to make it easier.

I was trying to work on the Summary tab. The search criteria is in the Raw tab.


I thought i can work it out using the formula given in the below link. but im getting an error. "#NA"


http://www.excelforum.com/excel-form...html?p=3168098


Please help.


Thank you in advance

[newdoverman]

Formula removed by me due to an error in it.

[Kevin UK]

@ newdoverman

You copy that across and down, it is going to be a right mess!

[newdoverman]

This should COUNT all the columns for each individual where the value is greater than 0:

Please Login or Register  to view this content.