Thread: i wish to lookup values in column A, & add adjacent values in colu
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Browny Browny is offline
external usenet poster
  
Posts: 40
Default i wish to lookup values in column A, & add adjacent values in colu
i wish to lookup values in column 'A' and sum the adjacent column(B)
eg.

A B
1 1 120
2 2 50
3 1 120
----------------------
240
The values of 1 in column A sum column B
--
Browny
Reply With QuoteReply With Quote