Using SUMIF Formula Help
Hey everyone!
I just started using Smartsheet and so far am blown away by everything! At the moment, I'm trying to use the SUMIF formula to calculate a total cost but only if the number being used is below 0. For example, If Column A is a negative number, I need the formula to subtract it from Column B, however, if Column A is a positive number, I need it to be added.
Is this even possible?
Comments

Hello Jessb,
I don't see any problem using a simple addition here. if column A is <0 (ex 3) you will have 3 + value in B or B 3. If A is >0 (ex 3) you will have 3+B.
In both case, you should have the correct value.
I hope this help
Maxime

SUMIFS should do the job just fine for you. In my screenshot below I used the following formula, based on my Columns.
=SUMIFS(Cost:Cost, [Column One]:[Column One], "Y")
This is only summing costs if my column titled Column One is Y.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.1K Get Help
 380 Global Discussions
 212 Industry Talk
 442 Announcements
 4.6K Ideas & Feature Requests
 140 Brandfolder
 129 Just for fun
 130 Community Job Board
 450 Show & Tell
 30 Member Spotlight
 1 SmartStories
 289 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!