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/
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
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/
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
No comments:
Post a Comment