how to sum the amount of cells with the same number in a column - Microsoft Excel 2010

Posted by jerlebrink on Super User See other posts from Super User or by jerlebrink
Published on 2013-10-30T09:25:50Z Indexed on 2013/10/30 9:58 UTC
Read the original article Hit count: 397

My english isn't that good, I hope you understand what I wan't to accomplish

I have a column (A) with different zip codes ( total of 3583 rows). I need a formula/function to go through each cell and the come up with sum of how many instances (column B) there are of the same zip code (column C).There are probably more than hundred different zip codes so I can't do it manually.

Thanks in advance.

© Super User or respective owner

Related posts about microsoft-excel-2010

Related posts about worksheet-function