Do you mean..

Formula in cell C1 with ColA and B with data

=A1&"(" & SUMIF(A:A,A1,B:B)&")"

--
Jacob (MVP - Excel)


"jojik" wrote:

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.