Excel Array Help


  Letter  Car  Value  Help

   A     Sedan   1       0

   B     Coupe   2 




Value is calculated via “=IFERROR(IF(SEARCH(“S”,B2,1), “1”), “2”)”


I have used an array in Help that reads 


“{=SUM(IFERROR(IF(SEARCH(“S”,B2:B3,1), “1”), “2”))}”


What i want it to return is 1 + 2 and so a value of 3, but i am getting back 0.

I need to keep the IFERROR as i have a more complicated code i am using that requires it.

By: Max Rothman

Leave a Reply

Your email address will not be published. Required fields are marked *