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
Check out the Formula Handbook template!