Thread: Sum Formula
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
鱼干 鱼干 is offline
external usenet poster
  
Posts: 1
Default Sum Formula
=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?


Reply With QuoteReply With Quote