I've looked around for answers regarding this, but am still a bit confused. I have a column A in Excel with dates in the format mm-yyyy (i.e. September 1014 is Sep-14). I want to add all the values in column H that fall in a particular month and year. So for example, I want to add all values that in Sep-2014. I'm trying to do this using SUMIF, but I don't know how to format the criteria. I have seen solutions advising to use an array...is there another, simpler way to do this? The dates are formatted in Excel and I have manually added them. I just don't want a large formula since I might be using this quite a bit in my spreadsheet and Excel tends to lag when file size is large on my computer.