| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SUM in VBA
I am trying to sum col L on Data Sheet if Col A on Sales Reps matches Col K
on Data Sheet.. I have attempted it below but i failed. Any help? Code:
With Range("L2:L5000")
sumL = 0
'assuming the row range is 2 to 5000
For r = 2 To 5000
If Cells(Worksheets("Sales Reps")(r, 1)).Value = Cells(Worksheets("Data
Sheet")(r, 11)) Then
sumL = sumL + Cells(Worksheets("Data Sheet")(r, 80)).Value
End If
Next
|
Threaded Mode
