Thread: Subtotal function 1 that excludes "#VALUE!"
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Subtotal function 1 that excludes "#VALUE!"
Get rid of the errors in the cells being subtotalled.

Trap for it in your formulas.

Post an example of two of the cells that return #VALUE! that are causing
the error in the Subtotal.


Gord Dibben MS Excel MVP

On Fri, 30 Jan 2009 12:09:01 -0800, JAbels001
wrote:


Reply With QuoteReply With Quote