Thread: SUM in VBA
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett Don Guillett is offline
external usenet poster
  
Posts: 10,124
Default SUM in VBA
why not just adapt SUMIF to the vba. See the vba help for using functions in
code

--
Don Guillett
SalesAid Software

"Busybee" wrote in message
...
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



Reply With QuoteReply With Quote