0 
Sheets("Create Summary").Range("B3").Value2 = _
    Excel.WorksheetFunction.CountIfs( _
        wsSourceData.[P:P], "Airports", wsSourceData.[AQ:AQ], "Not completed")

I'm trying to count all values other than "completed".

2
  • Try .CountIfs(wsSourceData.Range("P:P"), "Airports", wsSourceData.wsSourceData.Range("AQ:AQ"), "<>completed")
    – taller
    Commented Apr 17 at 4:36
  • thnk you, @taller
    – Anshu
    Commented Apr 17 at 5:43
Related questions
2173
How do I create an Excel (.XLS and .XLSX) file in C# without installing Microsoft Office?
628
Stop Excel from automatically converting certain text values to dates
643
How to avoid using Select in Excel VBA
Load 6 more related questions Show fewer related questions

0

Reset to default

Browse other questions tagged or ask your own question.