Help with if statement

[logixoner]

I am trying to create a weighted average grade book.The user can select what percentage to weigh each category. I have set up a row of cells to allow the user to be able to select one of the following categories: HW, PJT, FIN, WKS, TST. All the calculations will be computed out of the users sight. I need to create an if statement that will let a cell be zero if one of the fields mentioned above is not selected. In cell F38 I have tried =IF(D2:Y2<>"WKS",0,AVERAGEIF($D$2:$Y$2,"WKS",$D$3:$Y$3)),but for some reason it is not working correctly. Can someone please help me Ive been trying to figure it out for hours already and I'm sure its some thing simple. I have attached the file, so you can understand what im trying to say because its hard to type it out.

thanks in advance
GradeBook-1.xlsx

[tigeravatar]

logixoner,

I'd recommend using the Counif() formula to check if something exists within a range of cells:
=IF(COUNTIF($D$2:$Y$2,"WKS")=0,0,AVERAGEIF($D$2:$Y$2,"WKS",$D$3:$Y$3))

Attached is a modified version of your workbook so you can see how it works

Hope that helps,
~tigeravatar

[logixoner]

Tigeravatar,

Thank you sooooo much...this is exactly what i needed!!!

[Haseeb Avarakkan]

You can use IFERROR function,

=IFERROR(AVERAGEIF($D$2:$Y$2,"WKS",$D$3:$Y$3),0)

http://office.microsoft.com/en-us/ex...001231765.aspx