yogi_Pull From Sheet1 Records That Are Within The Date Range Of Today And Next 28 Days

                                          Google Spreadsheet   Post  #1212
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   May 27, 2013
user Alistair Fraser (http://productforums.google.com/forum/?zx=twarxl97ddra#!mydiscussions/docs/e12jwAERI4o)
How to set up a sheet to display selected rows from another sheet?
We would like to set up a sheet to display a list of rows from another sheet, which contain dates within the range: from today for the next 28 days.  These dates are in one of the columns of the source sheet.  The display sheet will look the same are the source sheet but just show the rows within the date range.
---
Thanks Yogi

I've tried to work it out, I think it's a QUERY, but not sure ...

Here a link to a sheet I've done to explain what I'm trying to do

https://docs.google.com/spreadsheet/ccc?key=0Agk9K8AL3znNdG82NDZkUEUyRGxmUG9DUEJWWDg3Rmc&usp=sharing 

Best Wishes

Alistair

------------------------------------------------------------------------------------------------------

yogi_Count Data Based On Criteria In Multiple Columns

                                          Google Spreadsheet   Post  #1202
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   May 19, 2013
user Alistair Fraser (http://productforums.google.com/forum/?zx=ttx1g8rgpf8v#!category-topic/docs/spreadsheets/sphDG8Ul6Q4)
How to count data in multiple colums?
I'm trying to find a formula to count data in multiple columns .  See example below.  

Name  Connection Type Disconnect Date

Anne         12 Month AP         5/24/2013

Jon          None

Fred          None

Jane          6 Month DD

Jack          None

Sue          12 Month AP          3/4/2013

Jim          None

Eric          12 Month AP

Bill          6 Month DD           4/25/2013

Ali          6 Month DD

Ray          12 Month AP

Frank 12 Month AP            5/1/2013

Julia          12 Month AP

Problem:

How to count total disconnects by connection type, like the manual example below

Total of 12 Month AP disconnects = 3

Total of 12 Month AP disconnects = 1

I have shared this sheet with the table above to test solutions  https://docs.google.com/spreadsheet/ccc?key=0Agk9K8AL3znNdDcwbHVVRlpmVjAxbTNPSWxmTWEzSkE#gid=0  

Could you let me know what formula to do this please?  Is it an array with countif?

Many thanks

---------------------------------------------------------------------------------------------------------------------------------

following is a solution to the problem