AVERAGE without including empty rows

[Summersim]

I need the average of both columns "Gimkit 1" and Gimkit 2, however certain rows are empty due to students being absent to class.

The average generated for each student included the empty rows which lowers the total average for each student because for their absent days the formula considered the marks as 0%

How do I solve this problem?

Any help will be greatly appreciated 😀

[TeeSee1 · Accepted solution]

If you know how to identify rows that should be excluded (or what should be included) then you can AND that condition with the Student name restriction.

SELECT(table[col],
 AND( 
  [St Name] = [_THISROW].[St Name],
  << your additional condition here>>
 )
)