Sumifs formula not working

[mamarabbit]

I have a workbook with multiple tabs that I update every other month with current data. I have one tab for data that I clear each time and copy the updated info into. (That info is copied from another excel spreadsheet, by the way.) On the second tab I have sumifs formulas set up to pull in certain data from the data tab. This setup has worked perfectly until today. I copied my data into the one tab but could not get the formulas to calculate. It looks like the formulas aren't picking up the data. I've checked to make sure the formulas are calculating automatically. I've retyped the formula. I've replaced the =. I tried naming the ranges I wanted the data to be picked up from. I've tried changing the format of the data - general, text, numbers, etc. I'm working in excel 2010 and cannot figure this out. Anyone have any suggestions? I'm super frustrated!

 

[Domenic]

It's possible that even though you've formatted the cells as General, the values are still being recognized as text values. If this is the case, we can coerce these text values into numerical values by doing the following...

1) Select an empty cell.
2) Copy the cell (Home > Clipboard > Copy).
3) Select the cells containing the data.
4) Home > Clipboard > PasteSpecial > Add > Ok

 

[mamarabbit]

Thanks for the reply Domenic. I found out the problem this morning. The guy who generates the excel spreadsheet that I get my data from had changed the format of some of the info that I had set up on my spreadsheet. The format had previously been 2Q2014 but he changed it to 2Q-2014. Small change that I didn't notice but caused me a huge amount of frustration. Lesson learned to check the really obvious things first!