Sumif Question
Answers
-
Try something like this:
=IF(OR(SUM([Column B]:[Column B]) > 0, SUM([Column C]:[Column C]) > 0), SUM([Column A]:[Column A]))
This will SUM the entire Column A, but only if either Column B or Column C have a numerical value in them. Is that what you were looking to do?
If you meant that the row in Column B or C contains numbers larger than 0, I would actually add in a helper column to the sheet to help filter down your criteria. For example, you could have a checkbox for the row to show if either of your criteria is met, like so:
=IF(OR([Column B]@row > 0, [Column C]@row > 0), 1, 0)
This would check a box if either Column B or C is greater than 0 for this specific row. Then your SUMIF would be very simple:
=SUMIF([Helper Column]:[Helper Column], 1, [Column A]:[Column A])
If I've misunderstood what you're looking to do, could you provide a screen capture of your sheet with an example of your desired outcome (but please block out sensitive data).
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
Thank you Genevieve,
I apologize for any confusion and thank you for your response. The second option is what I ended up going with.
Thanks again,
Steve
-
No problem at all! I'm glad one of these options worked for you 🙂
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!