Countif in VBA with Multiple Conditions

Originally Posted by Dord25

Thanks for the worksheet. Yes, I get 3 on the sheet. But when I add another condition like so:

MsgBox WorksheetFunction.Sum(Application.CountIfs(Range("A1:A28"), "Red", Range("B1:B28"), "Test1", Range("C1:C28"), Array(1, 2, 5, 6), Range("D1:D28"), Array(1, 3)))

I get 1, when we should get 2.

Attachment 855466

One array needs to be transposed - for example:

Application.Transpose(Array(1, 3))