If you are new to domains and looking to buy, sell and learn about domains then you have come to the right place. DNForum is the largest domain name community on the internet and continues to grow every day. There are over 105,000 domainers on DNForum doing everything from buying domains, selling domains, learning about domains and discussing domains. Take a minute and Register.
Register Today on DNForum IT'S FREE!
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=-
Pivot table report
Domain field in row
$ in data
JOES.com.au Graduate of the DNF College
try the COUNTIF command
I frequently find good help for my excel problems at http://www.excelforum.com
I'd just auto-filter it tbh with an autosum at the end,,, two seconds work, just as good results.
fini
Bookmarks