Thread: Using IF
View Single Post
 
Old 11-14-2010, 09:24 AM
nfphilpot nfphilpot is offline Windows XP Office 2007
Novice
 
Join Date: Nov 2010
Posts: 7
nfphilpot is on a distinguished road
Default

Quote:
Originally Posted by Kimberly View Post
or better yet, enter a unique list of the names in Col J for example, and put this in K1

=SUMIF($A$1:$A$5,J1,$B$1:$B$5)
and copy down for all the names
Would you mind giving me a quick example of this...cant figure exactly what you mean...

...thanks to the above formula, works a treat!
Reply With Quote