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 *