I have 3 spreadsheets. The first, €œSupplies Requests Received€� where Column
B contains the (duplicated) names of internal offices placing supply requests
(e.g., SNF, DGEN, CANM, etc.) and Column G contains each date a request for
supplies was received from that office.

Column B Column B
SNF 1//29/2009
DGEN 4/19/2008
CNMN 2/4/2009
ASEV 12/11/2008
SNF 2/3/2009
ASEV 9/16/2008
DGEN 5/1/2008

The second spreadsheet €œSupplies Delivered€� where Column A is a link of
Column B from the above €œSupplies Requests Received spreadsheet and Column G
(of Supplies Delivered€�) contains the names of ALL items delivered to that
office based on each supply request received.

Column A Column G
SNF 20 lb. white paper; #2 pencil; 11:1.1 black ink pen
DGEN 20 lb. white paper; 2:.2.12 toner cartridge; 11:9.9 red ink pen
CNMN #2 pencil, 31:01.9 desk calendar; 3:14.7 desk lamp
ASEV 25 lb. goldenrod paper; #2 pencils; 11:1.1 black ink pen
SNF 77:3.1 steno pad
ABEV 83:6.2 paper clips; 4:1.8 tape dispenser, 84:.8.3 desk stapler
DGEN 20 lb. white paper

The third spreadsheet, €œ2009 Master Supply List€� where Column A (A2:A200)
contains unduplicated supply item names, and the headings for Column B thru
Column E is the name of one of internal offices (i.e., SNF, DGEN, CNMN, ASEV,
etc.)

(Col B) (Col C) (Col D) (Col E)
Column A SNF DGEM CNMN ASEV
20 lb. white paper
#2 pencil
11:1.1 black ink pen
25 lb. goldenrod paper
77:3.1 steno pad
83:6.2 paper clips
4:1.8 tape dispenser
84:.8.3 desk stapler

I want the €œ2009 Master Supply List€� to count the number or times each
office is delivered any item listed on the €œ2009 Master Supply List€� during a
specific year (e.g., 2009). The problem, (a text string) multiple items are
listed in Column Gs cells of the €œSupplies Delivered€� spreadsheet; I cannot
figure a way to count a match from the €œ2009 Master Supply List€� with that of
the same item delivered to a specific office during a specific year. Any
suggestions would be much appreciated