Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMMING TOTAL BASED ON CHARATERS ENTERED IN CELLS
Hi Team,
I need your help on this. i would like to get the total of the characters in column D (TP,CS PS,BTP) and let the total of each characters placed under their respective type in column E,F,G,H) as below accordingly. I also need column (E,F,G,H) to update their total automatically whenever a new value is entered in column D with the same specified charaters as above. Below is only a sample of what i am working on but the data is quite large. I will be grateful if any of you could assist me with this excel work ASAP For further information, i can send you a detailed screen shot directly to your email. A B C D E F G H DATE OPENED CLIENT No. NAME TYPE TP PS CS BTP 20.05.201 125458 otim one TP 20.05.2011 123568 john b TP 20.05.2011 123568 okello PS 20.05.2011 123568 peter TP 20.05.2011 123568 han PS 20.05.2011 123568 hellen CS 20.05.2011 123568 simon BTP 20.05.2011 123568 walter CS 20.05.2011 123568 hon PS 20.05.2011 123568 gred PS 20.05.2011 123568 boyz TP 20.05.2011 123568 willo CS 20.05.2011 123568 sp BTP Rgds SP Lawsim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Summing data based on certain cells | Excel Worksheet Functions | |||
select value in table based on values entered in multiple cells | Excel Worksheet Functions | |||
Way to Concatonate cells in a row based on the order they were entered? | Excel Worksheet Functions | |||
FILL DATES IN VARIOUS CELLS BASED ON A DATE ENTERED IN A SINGLE C. | Excel Discussion (Misc queries) | |||
can excel draw a shape based on values entered in cells | Excel Worksheet Functions |