Sorry! Of course the function must be IF()!
Did you try the SUMIFS() part - without checking for zero sums. It will return 0 for cases, where no date was entered for course for this student, and when formatted as date, it will be displayed as date like 0.01.1900. This my be confusing, so I added the IF() part.
When this will not work, my 1st quess will be, the dates in your SourceDateRange aren't dates at all, but datestrings.
Btw, I add an example!
|