Help require to correct the sum formula

[mso3]

Hi,
I want to sum the average and grace marks in columns ‘bf’ and ‘bg’ respectively. The columns for average and grace are as follows:

Average: g8, m8, s8, y8, ae8, ak8, aq8, aw8, bc8

Grace: h8, n8, t8, z8, af8, al8, ar8, ax8, bd8

I’m getting wrong output in columns average total and grace total.

Please suggest me a correction in the formula.

Thanking you.

[FDibbins]

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[FDibbins]

Try this for the Average 100...
=AVERAGEIF($D$7:$BE$7,"Average
100",D8:BE8)
Note that you have a carriage-return in the Average 100 headings, either remove that and use a space, or include the CR in the formula
and this for Grace...
=AVERAGEIF($D$7:$BE$7,"Grace",D8:BE8)
You dont have any values in any Grace column

[pytheus]

BF8
=SUMIF($7:$7,"Average
100",8:8)

BG8
=SUMIF($7:$7,"Grace",8:8)

[FDibbins]

Thank you for the title change

[mso3]

Dear FDibbins,
Thank you. How to use cr in the formula because it's not possible to remove carrige-return. It reduce a column width.

Thank you.

[mso3]

Hi pytheus,
Thank you. The same problem for 'average 100'. I have used carrige return to reduce a size of column. So how to use cr in the formula?
The both formulas for grace are working fine.

Thank you.