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

=SUMIF(J4:J95,"OM",I4:I95)

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?

=SUMIF(H4:H95,"OM",I4:I95)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

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

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?

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?

=SUMIF(H4:H95,"OM",I4:I95)

"Stefi" дÈëÓʼþ
...
=SUMIF(J4:J95,"OM",I4:I95)

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?