Saturday, September 7, 2013

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:



Please help!
-------------------------------------------------------------------------------------------------------------------------------------------------------------

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