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
https://docs.google.com/spreadsheet/ccc?key=0An9pcZR1qnSXdEE2amd3aG9RUllDM1NSeTBhNlE2Mnc

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