COUNTIFS VBA Macro

[Vijaychitra]

Hi,

I'm able to get COUNTIFS results when the below formula's used in excel cell.

2 sheets are referred

=COUNTIFS('Sheet2'!L2:L1000,">90",'Sheet2'!F2:F1000,'Sheet1'!B5)
=COUNTIFS('Sheet2'!L2:L1000,">=3",'Sheet2'!L2:L1000,"<=5",'Sheet2'!F2:F1000,'Sheet1'!B5)

However, when tried to use the same formula in VBA, it doesn't return value/ unable to execute.
I have added " " to compile, no luck.

 

[vletm]

Vijaychitra
You cannot use same syntax with VBA.
Have You tried to 'Google' Your challenge?
eg excel vba countifs gives many solutions.

 

[Marc L]

Hi, according to Excel / VBA basics :​

Sub Demo1()
    MsgBox [COUNTIFS('Sheet2'!L2:L1000,">90",'Sheet2'!F2:F1000,'Sheet1'!B5)]
    MsgBox [COUNTIFS('Sheet2'!L2:L1000,">=3",'Sheet2'!L2:L1000,"<=5",'Sheet2'!F2:F1000,'Sheet1'!B5]
End Sub

Do you like it ? So thanks to click on bottom right Like !​

​