Thread: SUMIF
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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