View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK
 
Posts: n/a
Default Sum up values from adjacent column

Enter 2200 in C1 then in D1 enter this formula:

=SUMIF(A1:A9,C1,B1:B9)

This enables you to change the criteria in C1 without having to change
the formula - maybe relevant to your other post.

Hope this helps.

Pete