Sum Formula
Sorry this is for thread "empty cell instead of 0's" three lines below!
Stefi
€˛Stefi€¯ ezt Ć*rta:
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?
|