View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sloth Sloth is offline
external usenet poster
 
Posts: 252
Default Formula Help... sorry posted in new Users too (accident)

You will need a results row to compare to. You could use something like this
Name 16 15 ... 1 Total
RESULTS Pitts New Eng ... Dallas =136
Bob Pitts New Eng ... Dallas formula

enter the following formula (should be in R3 if I counted right)
=SUMPRODUCT(B$1:Q$1,--(B$2:Q$2=B3:Q3))
and copy down entire list of names.