View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Daniel.C[_3_] Daniel.C[_3_] is offline
external usenet poster
 
Posts: 133
Default to find the repetitve text from a column.

Use the SUMIF function.
Regards.
Daniel

JANUARY -44
JUNE - 20
FEBRUARY - 37
DECEMBER - 56
JUNE - 96
JUNE - 56
SEPTEMBER - 46
OCTOBER - 15
NOVEMBER - 87
DECEMBER - 66
DECEMBER - 12

dear All, i have this data in 2 columns and I want to show automatically in
one cell as 'december' and in the next cell the total of december (134).
please help me to sort out this. thanks in advance.