Sumifs and Dates

[Jambuba]

First time on here, so apologies if I am not doing something correctly.

Anyway, created a document for my company's sales teams that will allow them to better manage their $ spends. I want to utilize data that is already out there so they don't have to re-input it. So on the "merch spend" tab they would paste their spend data. Then it would add it all together by month and populate on the total spend tab. As you can see, I cannot figure out how to get it to work unless I have them manually enter the month in column K. I thought about doing a bunch of IF functions based on the number version of the dates, but then that would need to be changed each year. I also tried using the "mmmm" custom format, but that still relied on the number version of the date, so the total spend sumifs didn't work.

Any ideas how to get column K to auto populate into the text version of the month so the formula works on the "Total Spend" tab?

[alansidman]

In the Total Spend column you could change the month to a number and hide that row. In the row above use the Text name of the month.

[Jambuba]

Finally figured the right thing to ask google to get me what I needed. For those curious;

I used the formula =TEXT($F2,"mmmm") with F2 being the date in the format mm/dd/yyyy