LinkBack URL
About LinkBacks
You could try using SUMIF to determine the total value for an individual and COUNTIF to determine the number of occurrences of that individual's name and divide the latter into the former for the average.
Regards
You could try using SUMIF to determine the total value for an individual and COUNTIF to determine the number of occurrences of that individual's name and divide the latter into the former for the average.
Regards
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks