Hello,
So right now I have this formula which is working correctly:
{=SUM(IF(FREQUENCY(IF(Feb!$N:$N="ValidError",Feb!$D:$D),Feb!$D:$D),1))}
This array formula is essentially going and looking at a tab named “Feb” thathas a bunch of ID numbers (there are duplicates of the same ID number...