Thread: SUMIF Criteria
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dan dungan dan dungan is offline
external usenet poster
  
Posts: 411
Default SUMIF Criteria
If your data is in Column A, would this formula work for you?

=IF(AND(SUM(A1330),SUM(A13<=60)),SUM(A13),0)

Dan
Reply With QuoteReply With Quote