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.

Thank you


Rather than a SUMIF with one criteria, use SUMIFS so you can specify two criteria.

So you simply need to sum everything in column H where the value in column A is equal to, or after 1st September, AND before 1st October.


Another option is to use SUMPRODUCT and use MONTH and YEAR to establish conditions for inclusion in the sum.


This checks for the month being September and the year being 2014.

  • Andi's method worked, but I'll keep this in mind. Thank you! – Alti Oct 13 '14 at 16:17

Your Answer

