Sum parts of a column based on a category from another column

**Matchboxx** · 07-26-2012, 09:30 PM

I tried searching but I'm not very good with some of these advanced macros, so I'm not sure how to do it...but here's my predicament.

I am trying to manage all of my horse betting in Excel. In column "D," I have the amount of the bet, and in column "E" the type of bet (this will only ever be entered as one of the following: WIN, PLC, SHW, EXA, TRI, SPR). In column "G" I have the total cost of the bet.

Now, my primary concern is this - off to the side, I have "total spent on WIN," and "total spent on SHW," etc... how can I get the total amount from column "G" (since that will have the total for all horses, manually calculated by however many horses I typed in) only if, in the same row, the column "E" specifies "WIN?" This way I can get the total amount I'm spending on "WIN" bets.

Bonus points:

It would be even cooler if I could teach column "G" to automatically calculate the bet based on how many horses I type in. I always type in the horses separated by a comma and a space, such as "2, 7, 5" or if it's just one horse, then it's merely the number, such as "3" - any way to teach it to figure that out too without screwing up the first thing?

Thanks to anyone who can help!!

**dilipandey** · 07-27-2012, 01:00 AM

Hi Matchboxx,

Welcome to the forum.

Would suggest you to upload a sample workbook. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps.

**Matchboxx** · 07-27-2012, 01:03 AM

Hi,

Workbook I'm using is attached.

**dilipandey** · 07-27-2012, 01:21 AM

Hi matchboxx,

I believe you can use SUMIF function :-

Formula:

Please Login or Register  to view this content.

See attached file, blue cells :- Horse Betting.xls

Regards,
DILIPandey

<click on below 'star' if this helps>

**Matchboxx** · 07-27-2012, 01:29 AM

That helped immensely! Thank you!

**dilipandey** · 07-27-2012, 01:37 AM

You are welcome Matchboxx..

Cheers

Please mark this thread as [SOLVED]. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

**Cutter** · 07-27-2012, 07:43 AM

@ Matchboxx

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.