Excel Formula Error

[francoiscj1]

This is my formula in cell I13:

=IFERROR(SUM(--(UNIQUE(FILTER([NAME],([COURSE])*(tblTrainingLog[TRAINING DATE]>=Date(Year(Today()),1,1))*(tblTrainingLog[TRAINING DATE]<=Date(Year(Today()),12,31))*(tblTrainingLog[FREQUENCY]="One Time")*(tblTrainingLog[RETRAINING DATE]>=Date(Year(Today()),1,1))*(tblTrainingLog[RETRAINING DATE]<=Date(Year(Today()),12,31))*(tblTrainingLog[STATUS]="Compliant")))<>"")),"")

It is a missing parenthesis, but I can't figure out where I should place it. Attached is a sample of my spreadsheet where I want to count the total number of unique compliant courses by person for the year. Thank you for the help.

 

[RoryA]

What is the [COURSE] in the filter criteria meant to be doing, and why are you trying to sum names that are text?

 

[RoryA]

If the formula is in the tblTrainingLog table, I think you want:

=IFERROR(ROWS(UNIQUE(FILTER([NAME],([COURSE]<>"")*(YEAR([TRAINING DATE])=Year(Today())*([FREQUENCY]="One Time")*(YEAR([RETRAINING DATE])=Year(Today()))*([STATUS]="Compliant"))))),0)

If it isn't, then you need to qualify all the table columns with the table name.