Thread: SUMIF with non-adjancent cells
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default SUMIF with non-adjancent cells
Could you perhaps mean

=SUMIF(C10:C19,1,G20:G29)

Mike

"ismae" wrote:

Hi. Anyone knows how to use ranges of non-adjacent cells in a SUMIF function?

Reply With QuoteReply With Quote