Quote Originally Posted by BB1972 View Post
I presume you don't want a picture of the answer, so have a look at the attached workbook, which shows both SUMIF & SUMIFS formula doing what I think you want to do.
Thanks. I don't know how to upload a workbook on here yet (I just joined). The formula examples you gave are exactly the ones I've been trying to use.