Counting between worksheets

[joeyga]

Hi folks,

Noob at excel so would appreciate any help. I've attached an example.Excel question.xlsx

Worksheet 2: Column A lists the basket types
Worksheet 2: Column D lists a type of fruit that should be in the basket

Worksheet 1 should provide a count for the number of times a particular fruit has been mapped to a basket in worksheet 2. I've filled out basket 1 in the example.

Hope that makes sense and would appreciate any help.
Thanks,
Joe

[alansidman]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.