Thread: Function help
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
isabelle isabelle is offline
external usenet poster
 
Posts: 587
Default Function help

hi,

=SUMPRODUCT(--($H$1:$H$10=H1)*($I$1:$I$10))

--
isabelle



Le 2012-06-08 17:15, Ceej76 a écrit :

I have tried all that - I think I am doing something wrong - because it
doesn't work. That is why I am asking for help, because I can't figure
it out.