View Single Post
  #1   Report Post  
CHRIS K
 
Posts: n/a
Default SUMIF SUBTOTAL OR SUMPRODUCT?

I want to sum a row ignoring the highest (2) and lowest (2) values BUT some
of the cells have a #DIV0!
All I can get using sum and sub total and sumprod is #DIV0!

thanks
--
CHRISK