This one-liner worked at least four different Linux systems with different distros and versions.
echo "USER RSS PROCS" ; echo "-------------------- -------- -----" ; ps hax -o rss,user | awk '{rss[$2]+=$1;procs[$2]+=1;}END{for(user in rss) printf "%-20s %8.0f %5.0f\n", user, rss[user]/1024, procs[user];}' | sort -rnk2
USER RSS PROCS
-------------------- -------- -----
admtest 1974930 11
root 4544 736
gdm 78 12
ntp 14 1
postfix 5 2
messagebus 1 1
uuidd 0 1