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    Jan 16, 2013
user Christopher Pfaff said:(!category-topic/docs/spreadsheets/3-iBe-GqcLo)
count if matching any cell in given range of cells

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.

following is a solution to the problem