How to sum using vba
I am trying to sum data within excel using VBA.
What I what is a script theat adds data together everytime a criteria is met
for example
Everytime cells(r,1) = "Band1" then i want to add cells(r,2)
Band 1 may appear 500 time in 750 rows so I want to add all teh 500 together
I am sure this is not to difficult but I am just a novice.
Marcus
|