Microsoft Office Forums - View Single Post - Using IF

Thread: Using IF

View Single Post

Old

11-11-2010, 03:56 PM

Kimberly

Kimberly is offline

Kimberly uses Windows 7

Windows 7

Kimberly uses Office 2010 (Version 14.0)

Office 2010 (Version 14.0)

Expert

Join Date: May 2010

Posts: 517

Kimberly is on a distinguished road

Default

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

Reply With Quote