# Using SUMIF Formula Help

Options
✭✭✭✭
edited 12/09/19

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?

Tags:

• Options

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

• ✭✭✭✭✭✭
Options

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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!