Skip to main content
Web Applications

Return to Answer

added screenshot in case file disappears
Source Link
Jacob Jan
Jacob Jan
  • 23.3k
  • 16
  • 106
  • 195

Add the following formula in cell F2:

Formula

=ARRAYFORMULA(COUNTIF(C2:E5;B2:B5))

Explained

C2:E5 is the range in which the search is to be performed. B2:B5 are the search parameters. The COUNTIF function counts the occurrences and the ARRAYFORMULA will take on the complete range.

Screenshot

enter image description here

Add the following formula in cell F2:

Formula

=ARRAYFORMULA(COUNTIF(C2:E5;B2:B5))

Explained

C2:E5 is the range in which the search is to be performed. B2:B5 are the search parameters. The COUNTIF function counts the occurrences and the ARRAYFORMULA will take on the complete range.

Add the following formula in cell F2:

Formula

=ARRAYFORMULA(COUNTIF(C2:E5;B2:B5))

Explained

C2:E5 is the range in which the search is to be performed. B2:B5 are the search parameters. The COUNTIF function counts the occurrences and the ARRAYFORMULA will take on the complete range.

Screenshot

enter image description here

added 2 characters in body
Source Link
Jacob Jan
Jacob Jan
  • 23.3k
  • 16
  • 106
  • 195

Add the following formula in cell F2F2:

Formula

=ARRAYFORMULA(COUNTIF(C2:E5;B2:B5))

Explained

C2:E5 is the range in which the search is to be performed. B2:B5 are the search parameters. The COUNTIF function counts the occurrences and the ARRAYFORMULA will take on the complete range.

Add the following formula in cell F2:

Formula

=ARRAYFORMULA(COUNTIF(C2:E5;B2:B5))

Explained

C2:E5 is the range in which the search is to be performed. B2:B5 are the search parameters. The COUNTIF function counts the occurrences and the ARRAYFORMULA will take on the complete range.

Add the following formula in cell F2:

Formula

=ARRAYFORMULA(COUNTIF(C2:E5;B2:B5))

Explained

C2:E5 is the range in which the search is to be performed. B2:B5 are the search parameters. The COUNTIF function counts the occurrences and the ARRAYFORMULA will take on the complete range.

Source Link
Jacob Jan
Jacob Jan
  • 23.3k
  • 16
  • 106
  • 195

Add the following formula in cell F2:

Formula

=ARRAYFORMULA(COUNTIF(C2:E5;B2:B5))

Explained

C2:E5 is the range in which the search is to be performed. B2:B5 are the search parameters. The COUNTIF function counts the occurrences and the ARRAYFORMULA will take on the complete range.