Sumifs formula not working

mamarabbit

New Member
Joined
Dec 4, 2009
Messages
4
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! :confused:
 

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.
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
 
Upvote 0
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!:stickouttounge:
 
Upvote 0

Forum statistics

Threads
1,226,693
Messages
6,192,465
Members
453,725
Latest member
cvsdatreas

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top