Vlookup and count

[tigerrr]

Hi, attached is my sample file. Sheet1 will be the data input by user. In sheet2 i would like to vlookup and count the total. But not sure how to do it.
User will need to enter highlighted in yellow. Example user enter Red, it will vlookup Red colour in Sheet1 and count.

Help needed. Thanks.

[vba_php]

you don't need VLOOKUP() to count values. this will suffice:

Please Login or Register  to view this content.

[Pete_UK]

It's quite easy with COUNTIFS - put this in B5:

=COUNTIFS(Sheet1!$B:$B,$A$2,Sheet1!C:C,$A5)

Copy into D5 and F5, then copy down as required.

Hope this helps.

Pete

[tigerrr]

It's quite easy with COUNTIFS - put this in B5:

=COUNTIFS(Sheet1!$B:$B,$A$2,Sheet1!C:C,$A5)

Copy into D5 and F5, then copy down as required.

Hope this helps.

Pete

Thanks is working fine.