conditional summation

**thetrystero** · 06-01-2009, 05:24 AM

I have two columns of excel data and i'd like to sum all entries in one column that have the same criteria as determined by entries in the other column. for example here are my two columns

A 100
A 200
A 300
B 400
B 500
C 600
C 700
C 800

I'd like to turn this in to

A 600
B 900
C 2100

The list I have is very long, so it would be nice if there's some sort of formula to do this.

**DonkeyOte** · 06-01-2009, 05:28 AM

See: SUMIF function in XL Help
See: Pivot Table (see link in my sig for quick intro)

P.S. I'm liking your location...

**She543** · 10-30-2009, 03:16 AM

hi! i am also doing projection sales. when i got in this position they already have a template/formula for projection. I wanna know your idead about it. The formula is:
January projection = (day1-last cut-off sales/no. of days)*no. of selling days
in short January projection =(average daily sales)*no. of selling days

**DonkeyOte** · 10-30-2009, 03:18 AM

She543, Welcome to the Board, however, note:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.