Sum values based on criteria in another column

D

Derek Johansen

Essentially, what I am looking to do is go through a sheet and say:
If value of C3 matches value of C2, then add J2+J3, and then delete row 3.
If i was familiar with excel, or knew how to script/program in excel, i would
think it would be something like this (basic idea...)

n == 3
DO While (n < Number_of_rows)
DO While (Cn == C2)
J2 == J2 + Jn
Delete Row 3
End Do
n == n+1
END DO

^^ That would be check to see if the contents of column C matched the
contents of C2, and if they did, would sum the J column values in J2. I
would then have more code to check to see if any of the values of column C
matched the new value in C3, and would combine all J column values into J3.
Then check C4 and sum into J4, C5 sum J's into J5... Etc. All the way
through C(number of rows) into J(number of rows)

It's been a while since I did any real programming, and the only language i
even know is fortran, so sorry if that code is hard to follow... Any help
would be very much appreciated!!!
 
D

Don Guillett

Should do it

Sub Addupifmatch()
For i = Cells(Rows.Count, "c").End(xlUp).Row To 3 Step -1
If Cells(i, "c") = Range("c2") Then
mc = mc + Cells(i, "J")
Rows(i).Delete
End If
Next
MsgBox mc
End Sub
 
D

Derek Johansen

Okay, and now since I am a little slow, and haven't done much of anything in
excel, is there a good resource to actually learning how to implement that
bit of code into excel? I don't know really how to begin writing a
program/script for excel :-/
 
D

Derek Johansen

Okay, i figured out where to implement the VBA Script, but now my question is
What does the line mc = mc + cells(i, "J") do? Also, how difficult would it
be to implement this for every row? What i mean is: After it checks all the
values against Cell C2 and sums the total, it then checks the remaining
values against C3, and then against C4, etc...
 
D

Don Guillett

I can't seem to visualize what you really want so, if desired, send your
file to my address below along with a clear explanation and before/after
examples. Also, include a snippet of this msg.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top