Return invoice value if invoice number appears in a list

[John T]

Hi,

I need help with a formula, or the best way, to find out the total invoice value if the invoice number appears in a list.

I currently have a list of invoice numbers in column E and a value in column J for each invoice. There may be duplicates in this list with different values.
I then have a second list of invoice numbers that i need the total value of if the number appears in the first list. These are in column M and i need the total value in column N for that invoice number.

Thanks

 

[etaf]

sumifs( $J$2:$J$1000, $E$2:$E$1000, M2)
copied down
in fact a SUMIF() would do it

 

[Shloime]

if you want the total a basic sumfif should be used.
tye this formula in cell N2 and drag it down
=SUMIF($E:$E,$M2,$J:$J)

 

[John T]

Thank you. They both worked great.

 

[etaf]

you are welcome, just extend the rows to more than the data is likely to be - personally i dont like to use full column references as there are over 1 million rows and in some cases , excel calculates them all and known to slow down