Applying Formulae to Ranges

Hello folks. this is my first post here and I really need some help. this is my excel sheet :

\1

now I need two things.

1. in the K13,K14,K15 fields I need the average of the people. now I know that I can put " =(X+X) " for each and every field, but I need a formula, that I just write for one of them and then the excel itself calculate the rest of the averages. what can I do?

2. let's suppose the passing average is 12 (so IF anybody got the average under 12, the system should say failed). so in the J13,J14,J15 fields, I need the system to calculate and say if the student has passed the or failed. I think I should use the IF function but the problem is that I don't want to calculate each and every one of them myself. I need a formula so the excel itself could calculate the rest of the list. cause you know, there's like 45 students and I can't do all the 1. Averages, 2. Passed/Failed things for them.

many many thanks in advance

Re: K13 etc see AVERAGE function in XL Help

Please Login or Register  to view this content.

Re: L13 etc see IF function in XL Help

Please Login or Register  to view this content.

In terms of the formulae propagating for other lines see Fill Handle

Oh, I completely forgot about something.there are some numbers below the main words :

http://s3.postimage.org/n3h8yh5oi/Untitled2.jpg

these should multiply the lessons below them. I mean :

math*3
geography*4
physic*2
chemistry*3
history*2

so each and every lesson got its own value. now how can we calculate it? with the formula you gave me above, we can do the average thing (without the different values of every lesson), now can you pleas help me to do this too?

I mean for example, with these results :

math (12),geography(16),physic(7),chemistry(16),history(10)

the average of John would be 12+16+7+16+10 / 5 = 12.2
but each lesson has its own value, so John's average is actually this :

math : 12*3 = 36
geography : 16*4 = 64
physic : 7*2 = 14
chemistry : 16*3 = 54
history : 10*2 = 20

36+64+14+54+20 / 14 = 13.42

thanks

Originally Posted by zbor

If you don't put anything between quotes it will fill blank ""

For sake of clarity... Null String rather than a Blank
(I appreciate the above is what zbor was inferring)

RexG,

attach a sample workbook that fully outlines both requirements and expected results (calculated manually of course).

Workbooks invariably help (images not so much)

Please Login or Register  to view this content.

H3 as before.