Excel help Needed

[Adam Dicker]

Ok, I have created a bogus 2 column spreadsheet below:

domain 1 $1.53
domain 1 $21.25
domain 1 $2.03
domain 1 $65.04
domain 2 $14.20
domain 2 $15.20
domain 3 $42.90
domain 3 $56.70
domain 3 $22.30
domain 3 $112.30
domain 3 $55.17
domain 3 $99.45
domain 3 $51.26
domain 3 $21.60
domain 4 $25.00
domain 4 $36.78
domain 4 $6.59
domain 4 $8.21
domain 4 $4.52
domain 4 $14.98
domain 4 $354.21
domain 4 $25.10
domain 4 $78.60
domain 4 $99.90
domain 4 $256.30
domain 4 $213.00
domain 4 $214.25
domain 4 $12.38
domain 4 $25.17
domain 4 $545.00
domain 4 $36.35
domain 4 $15.42
domain 4 $12.28
domain 5 $0.10

Column A is the domain 1 and column B is the $ figure.

Is there a simple way to run a macro or something so that it will autmatically add up the $ totals in column A of like things in column A?

So i could just run a macro and have it give me the domain totals for domain 1, domain 2 and so on.

I do not just want to apply cell formulas as I am dealing with many spreadsheets over 60,000 lines. A macro of some sort would be much easier.

I hope this is clear enough.

Any help is appreaciated.

-=DCG=-

[Honan]

Pivot table report
Domain field in row
$ in data

[RWB]

try the COUNTIF command

[BigPete]

I frequently find good help for my excel problems at http://www.excelforum.com

[fini]

I'd just auto-filter it tbh with an autosum at the end,,, two seconds work, just as good results.

fini