View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
Fred Fred is offline
external usenet poster
 
Posts: 59
Default sumif where cells contain Number & Text


Biff/Don

Thanks guys for the help, Biff, the formula works a treat, although I
don't understand the Substitute action, it's all part of the learning
curve. The restrictions outlined were already identified, so not a
problem.

Thanks again
Regards
Fred