Thread: Sum Formula
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default Sum Formula

Try this instead of a single MAX(...)

=IF(MAX(...)=0,"",MAX(...))

Regards,
Stefi

€˛Phil H€¯ ezt Ć*rta:

I want to sum column I4:95 where the values in H4:95 are "OM" (without the
parens). What would the formula be?