Count Formula Needed

[MikeNorrisMOC]

Is there a simple count formula that I can input on sheet 1 in cell B1, B2 and B3 that I can copy down that will return the number of times Red, Blue and Green are listed on sheet 2? There are about 650 items that I need to have counted, so hoping there is something I can use that I can copy down to just reference whats in the cell on sheet 1.

Sheet 1
Cell A1 - Red
Cell A2 - Blue
Cell A3 - Green

Sheet 2 - All in Column A

Red Red Red Red Blue Green Blue Blue Blue Green Green Green Blue Green Green <colgroup><col width="64" style="width:48pt"> </colgroup><tbody> </tbody>

<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[Marcelo Branco]

Welcome to Mr Excel Forum

B1 copied down
=COUNTIF(Sheet2!A:A,A1)

M.

 

[jtakw]

Hi,

Based on your description:

=COUNTIF(Sheet2!A$1:A$1000,A1)

Change/adjust cell reference/range as needed.

 

[MikeNorrisMOC]

You are awesome Marcelo. Thanks so much

 

[Marcelo Branco]

You are welcome. Glad to help.

M.