Counting between worksheets

**joeyga** · 12-09-2014, 03:10 PM

Hi folks,

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

Worksheet 2: Column A lists the basket types
Worksheet 2: Column D lists Fruit example.xlsxa type of fruit that should be in the basket

Worksheet 1 should provide a count 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

**daffodil11** · 12-09-2014, 03:17 PM

B2:
=SUMPRODUCT((Worksheet2!$A$2:$A$53=$A2)*(Worksheet2!$D$2:$D$53=B$1))

OR

=COUNTIF(Worksheet2!$A$2:$A$53,$A2,Worksheet2!$D$2:$D$53,B$1)

They both operate under the same principles. Copy over and down as needed.

**BadlySpelledBuoy** · 12-09-2014, 03:18 PM

Try the below formula in cell B2 on Worksheet1 and copy to the right and down as needed.

Formula:

Please Login or Register  to view this content.

Worth noting that your details show you're using Excel 2003 but the attached file is .xlsx so must be from Excel 2007 or later.
If you ARE using 2003 then this formula will not work (you will need to use SUMPRODUCT instead). If you're actually using a later version than 2003 then you should update your details as this info can affect the solutions you're provided with.

BSB.