Help adding data if other cells are the same

  • Thread starter Thread starter m0cke
  • Start date Start date
M

m0cke

Hi,

I have a excel sheet with alot of purchase data,

One of the many columns has purchase order numbers, eg TH12345
In another column I have delivered prices, each order number can hav
multiple delivered prices against it.

I would like in excel to add the prices up as a total if the purchas
order number is the same, I need to do this for the whole sheet full o
order numbers and prices.

Example

TH12345 $13.45
TH12345 $2.54
TH12345 $6.54
TH12346 $1101.00
TH12347 $123.00
TH12347 $12.13

So I would like to add all TH12345 .. Then TH12346 .. Then TH12347 et
etc

Thanks for any help

Mo
 
Hi m0cke,

Have a look at the Countif() function.

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
Thanks for the replies.. I'm not sure this will work as the Purchas
Order numbers are not in sequence nor complete

ie I may have TH12345 then TH13675 then TH19765 etc etc

Not all numbers are available as the inappropriate data has bee
filtered out and I’m left with the data I wish to analyze.

So let me try to explain it a different way.

I have data in Column C, some of which is the same, If it is the sam
then I want to add up the data in Column D relevant to column C and pu
it in column E.

any ideas?


Mo
 
Hi
first try the suggestd solutions :-)
In your case SUMIF is probably what you want. enter the following in E1
=SUMIF($C1:$C1000,C1,$D$1:$D$1000)
and copy down

but you really should have a look at pivot tables. There's no need for
a sequence
 
In this case, just try one of them ( Franks).
I made an error, causing just a count of the number of occurences, rather
than the sum of them.

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *

Frank Kabel said:
Hi
first try the suggestd solutions :-)
In your case SUMIF is probably what you want. enter the following in E1
=SUMIF($C1:$C1000,C1,$D$1:$D$1000)
and copy down

but you really should have a look at pivot tables. There's no need for
a sequence
Click to expand...
 
Back
Top