try a sumif(), but it is always easier if you upload a sample file for us to look at