Thread: Sum of numbers with dependencie on another column
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
flummi
 
Posts: n/a
Default Sum of numbers with dependencie on another column
First set of data in A1:12
Second set of data in B1:B12

In C1 type: =SUMIF(A1:A12,"=23",B1:B12)

Hans

Reply With QuoteReply With Quote