DATE RANGE FORMULA
Hi,
Are you asking about pulling over data based on a data range or are you
asking how to bring over data that is not numeric?
=SUMPRODUCT(--(TEXT(Overall!H8:H2100,"mmm/yyyy")=TEXT(I1,"mmm/yyyy")),Overall!AI8:AI2100)
Another question about the above formula, why are you converting it to text
dates? since both components seem to be dates why not just leave them that
way.
=SUMPRODUCT(--(Overall!H8:H2100=A1),--(Overall!H8:H2100<=A2),Overall!AI8:AI2100)
Where A1 and A2 contain dates such as 1/1/2009 and 12/31/2009.
--
If this helps, please click the Yes button.
Cheers,
Shane Devenshire
"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.
|