=SUM(MAXIFS formula works in some cells and not others
Please help - this is driving me mad. See attached spreadsheet.
Column J in the 'Network Homes' sheet, is trying to return the latest date from Column C on the 'Job Occurrences' sheet, according to certain criteria in the formula.
Can any one tell me why the cells shaded pink in column J produce silly dates when others in the same column work ok?
I am somewhat of a novice, so would appreciate any help given.
|