Countif Criteria 1 and Criteria 2?

[Ark68]

Hello,

bpml = WorksheetFunction.CountIf(ws_data.Columns(8), "Klik Park" And ws_data.Columns(11), "Field")

This isn't working ...

Can someone help me accomplish what I thought this would do. I'm trying to get a count of all the values in which column 8 = "Klik Park" and column 11 = "Field"

 

[Fluff]

Change the function to Countifs & replace the word "And" with a coma

 

[Ark68]

Awesome Fluff! A new function under my belt!

 

[Fluff]

You're welcome & thanks for the feedback