Saturday, February 14, 2015

yogi_Count Number Of FAILED Where Column C In 'DATABASE' Contains 'Week-1" And So On

             Google Spreadsheet   Post  #1892
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Feb-14-2015
post by  Omaha77:
array formula help lookup colum for sum of 2 values
I am trying to lookup a column and look for 2 cell values within that column and return the sum
this is what i have that works for lookup of 1 value

 
=if(A4:A="","",arrayformula(sum((DATABASE!C:C=A4)*(DATABASE!I:I="FAILED"))))

thanks in advance
---------------------------------------------------------------------------