Thread: adding value only if criteria is true
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bondi Bondi is offline
external usenet poster
  
Posts: 94
Default adding value only if criteria is true

Hi gR,

If we say that your data is in column A and B then you can use SUMIF()
along the lines of :

=SUMIF(A1:A7,"=1",B1:B7)

Regards,
Bondi

Reply With QuoteReply With Quote