Excel – Using COUNTIF/COUNTIFS across multiple sheets/same column

by

This could be solved without VBA by the following technique.

In this example I am counting all the threes (3) in the range A:A of the sheets Page M904, Page M905 and Page M906.

List all the sheet names in a single continuous range like in the following example. Here listed in the range D3:D5.

enter image description here

Then by having the lookup value in cell B2, the result can be found in cell B4 by using the following formula:

=SUMPRODUCT(COUNTIF(INDIRECT("'"&D3:D5&"'!A:A"), B2))

More Related Contents:

  1. Save excel file multiple times with file names in another workbook.
  2. Read/Parse text file line by line in VBA
  3. How do I find the last column with data?
  4. Excel VBA: Answer gets “stuck”
  5. How to insert a picture into Excel at a specified cell position with VBA
  6. Save multiple sheets to .pdf
  7. Having multiple Excel instances launched, how can I get the Application Object for all of them?
  8. filter out multiple criteria using excel vba
  9. Excel VBA autofilter all but three
  10. How can I create a calendar input in VBA Excel?
  11. Cells.Find() Raises “Runtime Error 91: Object Variable or With Block Not Set”
  12. Excel VBA code to copy a specific string to clipboard
  13. Merge values of column B based on common values on column A
  14. How to import a table from web page (with “div class”) to excel?
  15. Excel VBA – Range.Copy transpose paste
  16. How to determine the last Row used in VBA including blank spaces in between [duplicate]
  17. How to give a time delay of less than one second in excel vba?
  18. Changing the date format to yyyy-mm-dd
  19. Delete all duplicate rows Excel vba
  20. In Excel, can I use a hyperlink to run vba macro?
  21. Select Newest Record and Create New Table of Unique Values in Excel
  22. Are ActiveX Controls Disabled?
  23. Excel Date Conversion from yyyymmdd to mm/dd/yyyy
  24. Best way to protect Excel VBA code? [closed]
  25. VBA copy rows that meet criteria to another sheet
  26. VBA Dialog box to select range in different workbook
  27. VBA: Remove duplicates fails when columns array is passed using a variable
  28. How to implement custom iterable class in VBA
  29. How can I loop through a subset of worksheets?
  30. VBA: Modify chart data range

Leave a Comment