View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jojik jojik is offline
external usenet poster
 
Posts: 9
Default To display repetitive text, one time, auomatically

JUNE - 20
DECEMBER - 56
JUNE - 96
JUNE - 56
DECEMBER - 66

dear All, i have this data in 2 columns and what I want is:
to appear 'june' automatically in one cell and in the next cell the total of
june (172). I got 172 by using 'sumif' function, but ;june' has to appear
automatically. please help me to sort out this. thanks in advance.