I have columns A & B and want to Sum the entries in Column B based on the
City in Column A as follows. I'm trying to Sum the number of Sales Reps in
each City:
City # Reps
Col A Col B
City 1 1
City 1 3
City 2 4
City 3 1
City 3 1
City 3 6

So I need to know how many Sales Reps are in City 1, City 2 and City 3, etc,
being able to use any US City name, ie, not "City 1", City 2", rather, say,
San Francisco, Las Vegas, Denver, etc

Seems like the =SUMIF() worksheet function would do what you need -
check the help on it and see...


--
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

Actually, SUMIF should work for the data given.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Gary" wrote in message
...
I have columns A & B and want to Sum the entries in Column B based on the
City in Column A as follows. I'm trying to Sum the number of Sales Reps in
each City:
City # Reps
Col A Col B
City 1 1
City 1 3
City 2 4
City 3 1
City 3 1
City 3 6

So I need to know how many Sales Reps are in City 1, City 2 and City 3,
etc,
being able to use any US City name, ie, not "City 1", City 2", rather,
say,
San Francisco, Las Vegas, Denver, etc

Thanks everyone. Could you give me an example of the SumIf formula? (Also, I
didn't realize anyone answered my question so I posted it again with another
example.)

"Don Guillett" wrote:

Actually, SUMIF should work for the data given.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Gary" wrote in message
...
I have columns A & B and want to Sum the entries in Column B based on the
City in Column A as follows. I'm trying to Sum the number of Sales Reps in
each City:
City # Reps
Col A Col B
City 1 1
City 1 3
City 2 4
City 3 1
City 3 1
City 3 6

So I need to know how many Sales Reps are in City 1, City 2 and City 3,
etc,
being able to use any US City name, ie, not "City 1", City 2", rather,
say,
San Francisco, Las Vegas, Denver, etc

Excel itself will walk you through that.

Click on the fx symbol in the little area just to the left of the
formula bar. This opens an "Insert Function" window. In the 'search
for a function' box, type SUMIF, then click the Go button.

This highlights the SUMIF entry in the box below. Click on the OK
button and you will get a window that guides you through setting up the
formula, or you could click the Help on this function hyperlink/hotspot
to get help with more information on how to use SUMIF.

It's always good to check with this built-in guide to functions when
you are trying to do something...


--
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

Thanks! I know how to do formulas, I'm just not sure how to do this
particular formula. Could you give me an example?

"jamescox" wrote:


Excel itself will walk you through that.

Click on the fx symbol in the little area just to the left of the
formula bar. This opens an "Insert Function" window. In the 'search
for a function' box, type SUMIF, then click the Go button.

This highlights the SUMIF entry in the box below. Click on the OK
button and you will get a window that guides you through setting up the
formula, or you could click the Help on this function hyperlink/hotspot
to get help with more information on how to use SUMIF.

It's always good to check with this built-in guide to functions when
you are trying to do something...


--
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

Did you read the help on SUMIF?

What's the part that you don't understand and what simple worksheet
tests did you make to see if you could figure it out?

(No offense intended, but I'm shooting for you to have a learning
experience here - if you just want me to give you the answer, you're out
of luck.)


--
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