General rule of development - make a simple example work, THEN integrate
it into your real workbook. Therefore, in a blanl worksheet create the
following:

1. In cell A4, type Cities and in A5 through A11, type Boston, Denver,
Los Angeles, Denver, New York, Denver, New York.

2. In cell B4 type Reps and in B5 through B11 type 1,2,3,5,4,1,2

3. In Cell E5 type Cities and in E5 through E8 type Boston, Denver,
Los Angeles, New York.

4. In cellF5 type the following formula:

=SUMIF($A$5:$A$11,E5,$B$5:$B$11)

5. Copy that formula down into F6 through F8.

Compare this working example with the help file writeup and see if you
can figure out where you went astray and what you need to change in your
workbook to get it working...

Happy 4th!


--
jamescox
------------------------------------------------------------------------
jamescox's Profile: http://www.thecodecage.com/forumz/member.php?userid=449
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=111550