I wanted to get the following from a worksheet. i have slno,names in A:B.and some adjectives of persons in C:H. in col I i have to counta the number of numerical entries from C:H.(it should not count zero)(avoiding the zero)then in col J, i have to get the average score that too with two decimals. and lastly in col K, i have to get the entries of the concerned adjectives for which numericals have been given.If I2=2 then in K2 there should be two text descriptions.If I3=5,then K3 should have 5 text descriptions which are given as col headings in C:H.thanks
i am attaching the sample excel sheet.

Hi Sumesh,

Am Tue, 26 Mar 2013 02:37:20 +0000 schrieb sumesh56:

I wanted to get the following from a worksheet. i have slno,names in
A:B.and some adjectives of persons in C:H. in col I i have to counta the
number of numerical entries from C:H.(it should not count
zero)(avoiding the zero)then in col J, i have to get the average score
that too with two decimals. and lastly in col K, i have to get the
entries of the concerned adjectives for which numericals have been
given.If I2=2 then in K2 there should be two text descriptions.If
I3=5,then K3 should have 5 text descriptions which are given as col
headings in C:H.thanks

for counting without zero:
=COUNTIF(C2:H2,"<0")
for Average without zero:
=SUM(C2:H2)/COUNTIF(C2:H2,"0")
for the adjectives:
=IF(C20,$C$1&", ","")&IF(D20,$D$1&", ","")&IF(E20,$E$1&", ","")&IF(F20,$F$1&", ","")&IF(G20,$G$1&", ","")&IF(H20,$H$1,"")



Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2