View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paul Black Paul Black is offline
external usenet poster
 
Posts: 394
Default SUMPRODUCT with a Twist

Hi everybody,

I have this formula which works great ...

=SUMPRODUCT(--ISNUMBER(MATCH(C14:H14,$C$3:$H$3,0)))

.... but I would like to add something to it please.
If the answer produced by the above formula is 5, I would like it to
check cell "I3" to see if that number matches any of the numbers in
cells "C14:H14". If it does then enter "5+", otherwise enter the
original result of 5.

Thanks in Advance.
All the Best.
Paul