Tuesday, January 15, 2013

yogi_Count Number Of Faults Based On Multiple Criteria

                                          Google Spreadsheet  Post  #971
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Jan 15, 2013
user Christopher Pfaff said:(http://productforums.google.com/forum/?zx=i1xirkbimh7#!category-topic/docs/spreadsheets/wpIjYzXtgVg)
count with specficed range

in Cell C15 I want to know how many Faults were reported in the month of April regardless of what type of electronic it was and matching the range I2:I7, then in cell D15, will be the same but only count if Item was returned.
following is a solution to the problem