HI ,
I inserted countif to calculate the count according to two criteria . but however I was thinking if it is possible to do it vba. someone please guide me (:
formula inserted in each cell of column B:E
=COUNTIFS(Sheet1!D:D,"B",Sheet1!E:E,"AIM1")
Printable View
HI ,
I inserted countif to calculate the count according to two criteria . but however I was thinking if it is possible to do it vba. someone please guide me (:
formula inserted in each cell of column B:E
=COUNTIFS(Sheet1!D:D,"B",Sheet1!E:E,"AIM1")
Code:count=WorksheetFunction.CountIf(Worksheets(1).Range("D:D"), "B")