Calculating an Average but ignore cells with no data yet

[DentonHTHS]

Hi,
I am working a sheet to average students weekly marks but would like to be able to give them their current mark and have excel ignore the assignment cells that don't have marks yet. This is what I have so far. I think it's an IF statement but not sure how to work it out completely.

Here's the formula I have so far.

=AVERAGE(D4,L4,T4,AB4,AJ4,AR4,AZ4,BH4,BP4,BX4,CF4,CN4,CV4,DD4,DL4,DT4,EB4,EJ4)

Thanks for any help.

 

[Jonmo1]

However it is returning a #Value! error

=AVERAGEIFS($D4:$EJ4,$D4:$EJ4,"<>0",$D$2:$DJ$2,"Grade for week")

All the ranges need to be the same size (that was my bad in my post..)
Try
=AVERAGEIFS($D4:$EJ4,$D4:$EJ4,"<>0",$D$2:$EJ$2,"Grade for week")

 

[DentonHTHS]

All the ranges need to be the same size (that was my bad in my post..)
Try
=AVERAGEIFS($D4:$EJ4,$D4:$EJ4,"<>0",$D$2:$EJ$2,"Grade for week")

Thank you! I didn't spot it either. I don't suppose there is a way to get rid of the DIV/0 if there are no marks at all yet?

 

[Jonmo1]

Use IFERROR for that

=IFERROR(AVERAGEIFS($D4:$EJ4,$D4:$EJ4,"<>0",$D$2:$EJ$2,"Grade for week"),"")