when I use the SUMIF formula to return data from a sheet, it returns 0, WHY?
When using the SUMIF formula, it should return specific data that I outline. However it returns 0. The sheet that contains the data does not display 0. my formula is not returning the correct data as if there is a miscommunication between the two sheets. Has anyone ever ran into this? Below if my formula.
=SUMIF({Verified/layout report form Range 1}, Rows@row, {Verified/layout report form Range 2})
What am I doing wrong?
Best Answer
-
Hi @Bailey H
Can you take a look at Range 2 that you want to SUM in the source sheet and see if the numbers are appearing on the left or right side of the cell? If the numbers appear on the left side of the cell, this indicates that they're actually being stored as Text instead of numbers (so the SUM would = 0).
How is Range 2 being populated in your source sheet? If you're using a formula to create the numbers, could you post the formula? It's likely we could either remove quotes around the number output to make sure it's numerical, or we could use a VALUE function to turn the data back into numbers.
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Answers
-
Hi @Bailey H
Can you take a look at Range 2 that you want to SUM in the source sheet and see if the numbers are appearing on the left or right side of the cell? If the numbers appear on the left side of the cell, this indicates that they're actually being stored as Text instead of numbers (so the SUM would = 0).
How is Range 2 being populated in your source sheet? If you're using a formula to create the numbers, could you post the formula? It's likely we could either remove quotes around the number output to make sure it's numerical, or we could use a VALUE function to turn the data back into numbers.
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!