View Single Post
 
Old 02-23-2016, 12:18 PM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

For each client...

=sumif(f:f,[client],e:e)/countif(f:f,[client])

modify the ranges as you see fit.
Reply With Quote