R
retseort
Need some help...
I have a column of ident number in column A.
In column B and C I have dollar figures.
I need to total all of the dollar figures in column B for all LIK
ident #s in column A.
example: In the case below I need to total all of the dollar amount
for each ident #, if the same ident # appears I need the sum of all it
gifts.
The file attached is an example. The first few Idents are unique s
they reflect only one gift. Ident # 56507 is reflected multiple time
and therefore needs to be totalled. The same for Ident #71571
The formula would need to check one ident # aginst the next one t
determine if it should total multiple gifts. The ident #s are sorted i
numeric sequence so it would not be necessary to match an Ident
against the entire list of Idents.
Thanks
Da
+-------------------------------------------------------------------
|Filename: excel sample.txt
|Download: http://www.excelforum.com/attachment.php?postid=3597
+-------------------------------------------------------------------
I have a column of ident number in column A.
In column B and C I have dollar figures.
I need to total all of the dollar figures in column B for all LIK
ident #s in column A.
example: In the case below I need to total all of the dollar amount
for each ident #, if the same ident # appears I need the sum of all it
gifts.
The file attached is an example. The first few Idents are unique s
they reflect only one gift. Ident # 56507 is reflected multiple time
and therefore needs to be totalled. The same for Ident #71571
The formula would need to check one ident # aginst the next one t
determine if it should total multiple gifts. The ident #s are sorted i
numeric sequence so it would not be necessary to match an Ident
against the entire list of Idents.
Thanks
Da
+-------------------------------------------------------------------
|Filename: excel sample.txt
|Download: http://www.excelforum.com/attachment.php?postid=3597
+-------------------------------------------------------------------