Macro needed

[ironsides]

macro needed

in cell P2
I want to count the positive numbers in col AK (starting row 19)
If col D reads "cap"

thanks
ironsides

 

[JoeMo]

Sub CapPositive()
With ActiveSheet
    .Range("P2").Value = WorksheetFunction.CountIfs(.Range("AK:AK"), ">0", .Range("D:D"), "cap")
End With
End Sub

 

[ironsides]

JoeMo Thanks for the macro, it works well...but i didn't explain myself completely
I think I need a condition format because in the D col, besides the "cap"
has 10 other classifications. sorry for my neglect.

 

[JoeMo]

You'll need to provide some more detail - I have no idea what additional capability you are requesting.

 

[ironsides]

Starts Line 19
Col D has 11 names (eng...cap etc
Col K has numbers, Pos and Neg

I want to search col D, all lines that have "eng" and
count in Col K, positive numbers for that "eng"
and put the number in cell W2

Formula needed to do this

Thank you Ironsides

 

[JoeMo]

In W2:
=COUNTIFS(D:D,"eng",K:K,">0")

 

[ironsides]

JoeMo, Thanks, I made proper adjustments and your formula works well Matt