Summing based upon condition

[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
+-------------------------------------------------------------------

 

[retseort]

TRied the SUMIF can't get it to work because the number of cells t
tally is a variable and not sure how to get Excel to adjust

 

[retseort]

Mr Shorty,

Well I did get the SUMIF to work but I can't figure out how to get it
to not give me the same total when in a group of like ident numbers.

So if the ident number is 74123 and the total for all idents # 74123 is
$300. I only want the $300 to appear on the first occurance of the
74123. Instead it shows up on every occurance.

My formula: =IF(R5=R6,SUMIF($R$2:$R$3000,R5,$S$2:$S$3000),T5)



Thanks
Dan

 

[retseort]

I GOT IT

final formula

=IF(AND(R5=R6,R5<>R4),SUMIF($R$2:$R$3000,R5,$S$2:$S$3000),T5)


The and function makes excel check to see if it is posting a duplicat
total and if so it populates the next dollar figure or blank

thanks Again

Da

 

[Bob Phillips]

Use the whole column

=SUMIF(A:A,"ident#",b:B)