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.

To display repetitive text, one time, auomatically
 

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.

To display repetitive text, one time, auomatically
 

Try this.
A1 to A5 has your months listed.
B1 to B5 has your values listed
F1 is the month you want to "SUMIF" , Jun or Dec.
(Can be a drop down data valadation list or just enter the month.)

In D1 enter this formula:

=F1&" "&SUMIF(A1:A5,F1,B1:B5)

Returns "Jun 172"

HTH
Regards,
Howard

"jojik" wrote in message
...
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.