Item Value Consolidation

Hello All,

I'm trying to find a way to consolidate a column of item numbers and their total price. Attached is an example document. I need to be able to paste in 500+ items in column A along with their price in column B and get the total amount for each item in column F. Any help would be greatly appreciated.

Thanks, I'll give it a shot.

In F2 - =SUMIF($A$2:$A$10,E2,$B$2:$B$10) and copy down

@ shg and BarryTSL

Thank you both. This just saved me a ton of time. I had over 500+ cells to calculate and this just saved me a ton of time. Thanks a ton!