Thursday, August 23, 2012

yogi_Extract From A Table Of Sales Data Sales Figures For Specified Dates Or Every Day Of A Specified Month

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #712   Aug 23, 2012     www.energyefficientbuild.com.

user SagRU said: (http://productforums.google.com/forum/?zx=xipg37otfzpe#!category-topic/docs/spreadsheets/NYrCdXlHL6o)
Advanced filtering
I'm trying to sum filtered data using advanced filtering. Advanced filtering = filtering values of one column according to values of another column (like VLOOKUP function). Here is my example: 
https://docs.google.com/spreadsheet/ccc?key=0AvHOD-oqzP4MdG83NF90VjJLQTAwTW42NS1GNThfRWc&pli=1#gid=1 
VLOOKUP doesn't work with SUM, so I have a very vague idea of how to perform such a task using more complicated functions. Thanks in advance!

------------------------------------------------------------------------------
following is a solution to the problem