Wednesday, January 16, 2013

yogi_Compute The Number Of Items returned In A Specified Month And Year That Are DOA or Faulty


                                          Google Spreadsheet  Post  #976
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Jan 16, 2013
user Christopher Pfaff said:(http://productforums.google.com/forum/?zx=yxsj47yocabe#!category-topic/docs/spreadsheets/3-iBe-GqcLo)
count if matching any cell in given range of cells


https://docs.google.com/spreadsheet/ccc?key=0An9pcZR1qnSXdEE2amd3aG9RUllDM1NSeTBhNlE2Mnc

In cell H8, I need it to count if April 2012, if Returned is yes, and total Returned count of DOA and Faulty

I came up with this but it doesn't work, but I want it to do something like that.

=COUNT(FILTER($A:$A,month($A:$A)=4,year($A:$A)=2012,$D:$D="yes",$E:$E=OR(K5:K6)))
---------------------------------------------------------------------------------------------------
following is a solution to the problem