Go to the JA Smith Excel Doc. This has lots of company data over time on the wei

Go to the JA Smith Excel Doc. This has lots of company data over time on the weight that they transported on that day. The company’s full name is “Jennifer Allen Smith International Incorporated”. But people spell is lots of different ways (smyth, JA smith, etc.). Also note that some weights are in “European format” and some are in USA format. (All dates are in USA format). 
Your task: For JA Allen, tell me the total weight they transported in August of all the years in the dataset.
Hints:
·      Look up Numbervalue() function
·      The sum of weights in all the Mays is 631886.94.
·      Should be done in 2 steps. First, identify those rows with Jennifer Allen Smith in them with some sort of indicator. Then use a ______ ________ to aggregate the weights by month, while also filtering on the indicator you chose.
A)   Put your answer here and upload your spreadsheet. 
B)    Tell me the formula you used. Please do not just filter or do this by brute force: try to come up with a formula that would work on new similar data but with new misspellings.

Posted in Uncategorized