Thread: HELP! Find Data in columns next to known data then Calculate
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
joel joel is offline
external usenet poster
  
Posts: 9,101
Default HELP! Find Data in columns next to known data then Calculate
I think you just need to learn how to use SUMPRODUCT. do a searchfor
SUMPRODUCT on this website. For your case of fred

=Sumproduct(--(H1:H100="Fred"),I1:I100)


Reply With QuoteReply With Quote