Thread: Sum Formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Stefi Stefi is offline
external usenet poster
  
Posts: 2,646
Default Sum Formula
=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