SUMIF
 

RESPECTED SIR,

A COLUMN CONTAINS NAMES THAT HAVE BEEN REPEATED RANDOMLY. A CORRESPONDING
COLUMN CONTAINS DIFFERENT VALUES FOR EACH OF THE REPEATED NAMES.

IS THERE A FORMULA I CAN USE AT HE END OF THE COULUMS GIVING THE TOTAL VALUE
FOR EACH NAME?

EXAMPLE ARE AS UNDER

COLUMN A COLUMN B
SAMEER 15
NADEEM 22
IDREES 09
SOBIA 01
MUZAMIL 12
SOBIA 15
NADEEM 12
SAMEER 09
..
..
..
..

==========================
ANSWERING IN FOLLOWING CONDITION

NAME TOTAL
---------------------------------------------
SAMEER ??
NADEEM ??
IDREES ??
SOBIA ??
MUZAMIL ??

i want sum of each person with help of fomula.

an urgent response will be highyly appreciated.

Regards
Malik Nadeem
cell # 0092 300 2556512

SUMIF
 

Hi,

Try this

=SUMIF(A1:A8,C1,B1:B8)


C1 contains the name you want to sum for.

Mike

"Malik Nadeem" wrote:

RESPECTED SIR,

A COLUMN CONTAINS NAMES THAT HAVE BEEN REPEATED RANDOMLY. A CORRESPONDING
COLUMN CONTAINS DIFFERENT VALUES FOR EACH OF THE REPEATED NAMES.

IS THERE A FORMULA I CAN USE AT HE END OF THE COULUMS GIVING THE TOTAL VALUE
FOR EACH NAME?

EXAMPLE ARE AS UNDER

COLUMN A COLUMN B
SAMEER 15
NADEEM 22
IDREES 09
SOBIA 01
MUZAMIL 12
SOBIA 15
NADEEM 12
SAMEER 09
.
.
.
.

==========================
ANSWERING IN FOLLOWING CONDITION

NAME TOTAL
---------------------------------------------
SAMEER ??
NADEEM ??
IDREES ??
SOBIA ??
MUZAMIL ??

i want sum of each person with help of fomula.

an urgent response will be highyly appreciated.

Regards
Malik Nadeem
cell # 0092 300 2556512

SUMIF
 

Another way if you want the sum in column C. Put this in C1 and drag down.

=IF(COUNTIF(A1:A$1,A1)1,"",SUMIF(A$1:A$8,A1,B$1:B $8))

Mike

"Malik Nadeem" wrote:

RESPECTED SIR,

A COLUMN CONTAINS NAMES THAT HAVE BEEN REPEATED RANDOMLY. A CORRESPONDING
COLUMN CONTAINS DIFFERENT VALUES FOR EACH OF THE REPEATED NAMES.

IS THERE A FORMULA I CAN USE AT HE END OF THE COULUMS GIVING THE TOTAL VALUE
FOR EACH NAME?

EXAMPLE ARE AS UNDER

COLUMN A COLUMN B
SAMEER 15
NADEEM 22
IDREES 09
SOBIA 01
MUZAMIL 12
SOBIA 15
NADEEM 12
SAMEER 09
.
.
.
.

==========================
ANSWERING IN FOLLOWING CONDITION

NAME TOTAL
---------------------------------------------
SAMEER ??
NADEEM ??
IDREES ??
SOBIA ??
MUZAMIL ??

i want sum of each person with help of fomula.

an urgent response will be highyly appreciated.

Regards
Malik Nadeem
cell # 0092 300 2556512