SUMMING TOTALS BASING ON CHARATERS ENTERED IN CELLS OF ONE COLUMN

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 ID NO. NAME TYPE TP PS CS BTP
20.05.2011 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
Lawsim SP
 
P

Pete

This calls for the SUMIF function.

If you want the total of each type in row 2 at the top under each TYPE
column heading, begin your data table at A3

In E2, place =SUMIF($D:$D, E$1,$B:$B). Drag this formula across from
E through H.
The E$1 will adjust automatically to cover the other TYPE column
headings.

Pete
 

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

Top