Thread: SUMIF
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Malik Nadeem Malik Nadeem is offline
external usenet poster
 
Posts: 44
Default 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