yogi_Compute Month By Month Total Tonnage Shipped From Shipping Data By Date In Another Spreadsheet (yogi_Shipping Update)

                                          Google Spreadsheet   Post  #1360
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Sep 07, 2013
user rsurflong (http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/pT3LgRgVcrM)
Import the Sum of Date Ranges into another Google Doc
Hello,

I maintain a Shipping Update and Monthly Tonnage spreadsheet at work. 

I am wanting to import the sum of a range of dates from one Google Doc to another.

For example: I need the total weight of all trailers shipped from 8/1/2013 to 8/31/2013 from the Shipping Update imported into Shipping Tonnage Doc.

Here are samples of the spreadsheets:

First Sheet: https://docs.google.com/spreadsheet/ccc?key=0AvSvfH_bXSDKdHhDS2p4Nld2cFBPbDhGaVY5X3NPT3c#gid=0

Second Sheet: https://docs.google.com/spreadsheet/ccc?key=0AvSvfH_bXSDKdHNtNTdJQzlCWTBxVmtrSEZoTW43M2c#gid=0

Please help!

-------------------------------------------------------------------------------------------------------------------------------------------------------------

here is an image of Sheet1 in the source spreadsheet yogi_Shipping Update