Friday, December 18, 2015

yogi_Compute By item In Column B Sum Of Numbers In Column C By Specified Month(s)

Google Spreadsheet   Post  #1992
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Dec-18-2015
post by  Gilbert sampayan:
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/I3kQjO-RYCk;context-place=forum/docs

Filtering data using a formula

is it possible to have a formula to automatically filter my data so it will only return data from a given range?

Example:

I need to get total Count per Type only from 12/01/2015 to 12/31/2015 then from 01/01/2016 to 01/31/2015

https://docs.google.com/spreadsheets/d/1q7plr0lW7Jt0FFLNRADGgGcdb6bbW35ydlI1mJ29wC4/edit?usp=sharing
------------------------------------------------------------------------------------------