SUMMING TOTAL BASED ON CHARATERS ENTERED IN CELLS

L

Lawsim

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMMING TOTALS BASING ON CHARATERS ENTERED IN CELLS OF ONE COLUMN 2
Error in if condition 1
Running totals when letters entered. IF statement 0
autopopulate based on a cell value 2
Count text cells if condition in row is true, over many rows. 0
sum a set of cells based on comparing a different set of cells 3
Word Error Message: This file is corrupt and cannot be opened 1
Conditional Sumproduct() Based on the Time of the Day 3

Top