Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create a shortcut for repetitive text | Excel Discussion (Misc queries) | |||
Display time in text | Excel Worksheet Functions | |||
Auomatically updatting formula when cell is not blank | Excel Discussion (Misc queries) | |||
if a cell contains text, then display date and time | Excel Discussion (Misc queries) | |||
repetitive | Excel Discussion (Misc queries) |