View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tacrier Tacrier is offline
external usenet poster
 
Posts: 44
Default SUMIF based on duplicates?

Hi there,

I have 3 columns like this:

A B C
200.00 998
500.00 999
505.00 1101
90.00 1101
$100.00 1300
$50.00 1300
$22.00 1300
$400.00 2400
30.00 2400
4000.00 2500


I would like to input a $ total in column D of each duplicate # in column C.
For example the $ total for 2400 is $430.00.

Sounds simple, but it is Friday and my brain is on Saturday mode. Is there
a formula I can input into column D?

Thanks for any help on this.