Thread: help with sum if function
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 help with sum if function
Do you mean Rows O20 to O33, if so try:-

=IF(C14="N",SUM(O23:O33),"")

Mike

"bl_johnson_19" wrote:

How can i use sum if function to sum numbers in columns O20:O33 only if cell
C14 has a "N' in it.


Reply With QuoteReply With Quote