Countif With Multiple OR Criteria

by

You could use the VBA equivalent of a standard COUNTIF formula (which can take more than one argument). This can be expanded as required

Standard Formula
=SUM(COUNTIF(A:A, {"SAL","PRE"}))

VBA Equivalent
MsgBox Evaluate("Sum(COUNTIF(A:A,{""PRE"",""SAL""}))")

More Related Contents:

  1. Want to concatenate multiple row data in in cell along with its values if present. Emp Id should not come if no data available infromt of it
  2. Excel Number Separation [closed]
  3. Excel formula checklist in employees
  4. Sequence of numbers based on start and end value of 2 cells [closed]
  5. Error in finding last used cell in Excel with VBA
  6. Excel VBA – How to add dynamic array formula
  7. Filling any empty cells with the value above
  8. Find last used cell in Excel VBA
  9. Count unique values in Excel
  10. Concatenate column headers if value in rows below is non-blank
  11. How do I apply a SumIf Formula in a VBA Sub? Getting Error 1004
  12. How to extract text within a string of text
  13. How to roundup a number to the closest ten?
  14. MS Excel: insert a row automatically if the content in a cell is <> that in cell of the last row?
  15. vba excel: how to copy characters from a cell to another
  16. Microsoft Excel ActiveX Controls Disabled?
  17. What is the default scope of worksheets and cells and range?
  18. Simple Pivot Table to Count Unique Values
  19. Are there disadvantages in putting code into Userforms instead of modules?
  20. Excel UNIQUE Across Columns
  21. Detect if range is empty
  22. Assign keyboard shortcut to run procedure
  23. Uncheck all checkboxes across entire workbook via CommandButton
  24. return csv file as recordset
  25. VBA workbooks.Close without being prompted to if the user wants to save?
  26. EntireRow.Delete performance issue
  27. How to extract groups of numbers from a string in vba
  28. Delete all data rows from an Excel table (apart from the first)
  29. Excel Hide/Show all tabs on Ribbon except custom tab
  30. Excel VBA Run-time Error ‘32809’ – Trying to Understand it

Leave a Comment