What I can think of is temporarily copying the 4 person name columns into 1 column, then use advanced filter to get a unique list.. then use the SUMIF/COUNTIF formulas on that unique list.