Unfortunately cannot get it to work, it only shows zeros. It should show the
totals I entered in €œ2009 Master Supply List€� below. (I also corrected
€œSupplies Request Received€� Column reference.)

€œSupplies Requests Received€�
Column B Column G
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


€œSupplies Delivered€�
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
ASEV 83:6.2 paper clips; 4:1.8 tape dispenser, 84:.8.3 desk
stapler
DGEN 20 lb. white paper


€œ2009 Master Supply List€�
Column A (Col B) (Col C) (Col D)
(Col E)
SNF DGEN CNMN
ASEV
20 lb. white paper 1 2 0
0
#2 pencil 1 0
1 1
11:1.1 black ink pen 1 0 0
1
25 lb. goldenrod paper 0 0 0
1
77:3.1 steno pad 1 0 0
0


"Luke M" wrote:

This assumes the dates you have on first sheet are actually entered as dates
In B2
=SUMPRODUCT(('Supplies Requests Received'!$A$1:$A$100=B$1)*(YEAR('Supplies
Requests Received'!$G$1:$G$100)=2009)*(ISNUMBER(FIND($A2,'S upplies
Delivered'!$G$1:$G$100))))

Adjust array sizes as needed. You should then be able to copy this cell down
and to the right to get totals for rest of your data. Note that you could
change the '2009' to a cell reference somewhere, to make formula more dynamic.


--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Chapi" wrote:

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