With Date in cell A1 of your current sheet and your data in 'Target' (row 1
with headers); the below formula will give you the total for the month of
date mentioned in cell B1

=SUMPRODUCT(--(TEXT(Target!B2:B100,"mmm/yyyy")=TEXT(A1,"mmm/yyyy")),Target!C2:C100)


If this post helps click Yes
---------------
Jacob Skaria


"roy.okinawa" wrote:

I use this formula when I want total number from another worksheet to a
target worksheet:

=SUMPRODUCT(--(TEXT(Overall!H8:H2100,"mmm/yyyy")=TEXT(I1,"mmm/yyyy")),Overall!AI8:AI2100)

Is there a formula I can use with a date range that will pull data across to
another worksheet (target worksheet?) Example of what target worksheet would
look like:

Date: 7/10/2009

WO# DATE RCVD COST REMARKS

Thanks.