Advertisement
Guest User

Untitled

a guest
Apr 16th, 2014
50
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.39 KB | None | 0 0
  1. rng = ThisWorkbook.Sheets("sheet1").Range("k3:k" & lastrow)
  2. rngl = ThisWorkbook.Sheets("sheet1").Range("n3:n" & lastrow)
  3. For us = 11 To 22
  4. On Error Resume Next
  5. Range("b" & us).Value = Application.WorksheetFunction.SumIf(rng, j, rngl)
  6. Range("c" & us).Value = Application.WorksheetFunction.CountIf(rngl, j)
  7. Range("d" & us).Value = (Range("b" & us)) / (Range("c" & us))
  8. j = j + 1
  9. Next us
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement