Count and sum formulas not returning correct values
I have some simple count and sum formulas that are not returning the correct values. Is there a way to fix this and what might be the problem? In some parts of my master datasheet they are calculating correctly but not in others. Thanks!
Answers

Can you post a screenshot of the formulae and/or data? Without context, it'd be hard to nail an answer.
If you have numbers that show as text, sometimes formulae won't recognize them. Reformatting can fix, but doesn't always grab all data for certain reasons.

Hi Austin,
It seems like maybe there was just a lag as now everything looks correct on the sums. When I submitted my question earlier, the total count in the first column was 148 (I added a second column where I just typed in the values to test the sum function) I guess there was just a delay? How long does it typically take for data to calculate. Sometimes it seems to calculate instantly, but other times much longer and it is hard to know if I have a problem with a formula or not.
In the total projects count, I actually changed my formula because I was scared it was maybe counting my column header as a value. Originally I had, =COUNT({Project Name}, 1) which yields a count of 169 but have changed it to =COUNTIF({Project Name}, <>" ") which yields a count of 168, which is correct. I would have thought they would have returned the same values...
Thank you!

It happened again today but this time a got a screen shot. The values on the right represent manual counts. These were both equal earlier today but now they are off. The column with a count of 63 Not Started projects are the formula counts. Why are these not updating properly? Everything has been saved.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.5K Get Help
 62 Global Discussions
 46 Industry Talk
 386 Announcements
 3.5K Ideas & Feature Requests
 54 Brandfolder
 125 Just for fun
 50 Community Job Board
 466 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!