Conditional If statement?

[Spajeoly]

This is a weird one, I am helping a friend with a spread sheet that tracks dollar amounts and who handled them basically.

There is a collumn with names in it that have a dollar amount next to them. What we need is for Excel to add up all the dollar amounts in the range according to what name is in the corrisponding collumn.. This is what it lookes like kind of...

I gott do this in VBcode tags or the spaces get jacked....

Name     Amount
 
John      $10,000
Bill        $500
Jody      $3,000         
John     $100
Jody      $50
 
Totals
Name       Total Amount      Amount processed
 
John        $10,100               2
Bill         $500                1
Jody        $3,050                 2

I could do this in VBA but he is not allowed to use VBA for whatever reasons, so this would have all be done with formulas.

We already got the formula to count how many entries there are per name but I can't seem to figure out how the dollar amount could be added up into the total cell going by what name is in the other collumn.

Any help is greatly appreciated, thanx, I will be reading up on the subject in the meantime. Thanx.

[davidfongchoy]

Since you can't make a custom formula with VBA, I think using an Excel pivot table will do the trick.

[Spajeoly]

That's another problem, I asked if I could just make a new workbook to do the same thing but they want to keep the same design and refuse to change lol.

My books are all at work, I will look through them tonight and see whatweird trick I might be able to figure out.

Thanx for your reply.

[davidfongchoy]

Have your tried array formulas? Here's the exerpt from the Excel's Help. I've never used them, but it sounds like it might be what you are looking for.

About array formulas and how to enter them

An array formula can perform multiple calculations and then return either a single result or multiple results. Array formulas act on two or more sets of values known as array arguments. Each array argument must have the same number of rows and columns. You create array formulas the same way that you create basic, single-value formulas. Select the cell or cells that will contain the formula, create the formula, and then press CTRL+SHIFT+ENTER to enter the formula.

If you want only a single result, Microsoft Excel may need to perform several calculations to generate that result. For example, the following formula averages only the cells in the range D515 where the cell in the same row in column A contains the text "Blue Sky Airlines". The IF function finds the cells in the range A5:A15 that contain "Blue Sky Airlines" and then returns the value in the corresponding cell in D515 to the AVERAGE function.
{=AVERAGE(IF(A5:A15="Blue Sky Airlines",D515))}

[Spajeoly]

That just might do it though I will have to experiment later on as I need to go to work right now due to unexpected changes in plans, I hate people who have no communication abilities....

[opus]

I did put together an example using my EXCEL.
Since I use it in GERMAN, I can't post the Formula.
I hope you get it when you open it on your PC.

[Spajeoly]

Perfect man, perfect.

Thanx a ton, I was going to tell him TS lol.