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

user SagRU said: (!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: 
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