Using SUMIF Formula Help

Jessb9187

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?

Maxime Schmidt

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

Mike Wilday

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.