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
[TABLE="width: 64"]
<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64, bgcolor: transparent"][TABLE="width: 64"]
<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64, bgcolor: transparent"]Red [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Red [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Red [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Red [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Blue [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Green [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Blue [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Blue [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Blue [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Green [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Green [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Green [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Blue [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Green [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Green [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]

 

[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.