Thread: Calculating sum based on value in adjacent column
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
[email protected] martin_pentreath@hotmail.com is offline
external usenet poster
  
Posts: 6
Default Calculating sum based on value in adjacent column
bigwheel wrote:
use SUMIF e.g. =SUMIF(A1:A50,"Jane",B1:B50)

Many thanks bigwheel and Richard, that's what I needed.

Reply With QuoteReply With Quote