VBA to count rows based on two columns values

[rosscortb]

Hello

I can't work this out. I want to count the rows but only if the column M equals Asset Mgt and column N equals Business Dev. How do I add the column n piece please?
Thank

Ross

With Sheets("Asset Mgt")
Counts = Application.CountIf(.Range("M:M"), "Asset Mgt"






MsgBox Counts

 

[SteveO59L]

Re: Help using vba to count rows based on two columns values

something along the lines of
Dim c As Range, rng
Dim lr As Long
Dim asset_mngmnt As Integer

lr = Range("m" & Rows.Count).End(xlUp).Row
Set rng = Range("m1:m" & lr)
For Each c In rng
If c.Value = "Asset Mgt" And c.Offset(0, 1).Value = "Business Dev" Then
asset_mngmnt = asset_mngmnt + 1
End If
Next c
Range("o1") = asset_mngmnt

 

[rosscortb]

Re: Help using vba to count rows based on two columns values

Thank you v much