Most valuable professional
  • Hot Topics

Excel Counting with multiple criteria and different tables

I have many different tables all on one worksheet, with identical data in appearing in more than one table, but never more than once per table. It looks something like this: Table 1 Name | Data 1 | Data 2 | Data 3 | Data 4 Table 2 Name | Data 2 | Data 4 Table 3 Name | Data 3 | Data 4 Table 4 Name | Data 2 | Data 3 | Data 4 Is there a formula that can give the me total number of times that both Data 3 and Data 4 appear together in all the tables? I.e. Data 3 and Data 4 both appear in Table 1, 3, & 4 so the formula should give me the number 3.

This question generated 26 answers. To proceed to the answers, click here.

This thread is current as of November 29, 2013.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel